Thanks a lot for the feedback, Dirk and Mehmet,
My (large) test-code is in RUnit and so I'm glad to hear that it is fine.
RUnit worked very well for me and I do not have a reason to switch.
[[alternative HTML version deleted]]
__
Hello,
I see that quite some packages nowadays use testthat and that RUnit doesn't
have recent updates. On the other hand Rccp, fTrading and others (still)
test with RUnit.
My old code uses RUnit and I would prefer to keep it that way unless there
is an important reason to switch to testthat. If
Since some years I have the following domains which I don't need any longer
(and in fact never used despite some plans)
- developr.org
- editr.org
- helpr.org
It makes no sense to hoard domains and I plan to give them away for a 'good
cause'. I'd like to have a small fee for the costs but
2011/11/15 jim holtman jholt...@gmail.com:
Part of my problem has to do with getting through the corporate
firewall to access the other program I have to download to use it. I
just tried today and this is what I got:
xls.getshlib()
Loading required package: tools
--- xls.getshlib
Jim,
2011/10/15 jim holtman jholt...@gmail.com:
You might also want to consider the XLConnect package. I have had
better luck reading/writing Excel files than with xlsReadWrite.
XLConnect looks good but - as the xlsReadWrite author and planing to
release a xlsx/64 bit successor - I'd be
Some years ago I travelled through Libya and it's with much emotion
that I follow the news.
The license below is dedicated to Mohammed Nabbous and will let you
run xlsReadWritePro for free (Windows, R 32-bit):
library( xlsReadWritePro )
xls.lic( action = register,
miscData = list(
The xlsReadWrite[Pro] package allows to natively read and write Excel
files (.xls) on the Win 32-bit platform.
Changes:
o fix bug with integer conversion (http://dev.swissr.org/issues/113)
PROBLEM: values outside the integer range (i.e. 12345678901) didn't give an NA
(and a warning
Toby, haruo0409,
2010/12/8 tkdweber tkd.we...@gmail.com:
This is my Error-Message in its German original:
Fehler in .Call(ReadXls, file, colNames, sheet, type, from, rowNames, :
Falsche Anzahl von Argumenten (11), erwarte 10 für ReadXls
There was a wrong DLL for a short while in the old
The xlsReadWrite[Pro] packages allow to natively read/write Excel files (.xls)
on the Win 32-bit platform.
About a week ago new package versions have been released:
* xlsReadWrite 1.5.3 is available at CRAN (for R2.11/2.12) and from
www.swissr.org/download (binary builds for R2.9 - R2.12)
*
Argh, just now I saw a scrambled start-up message when running
xlsReadWrite1.5.2 in R2.12.0 (32-bit) on a Win7 64-bit platform. If
you have this situation and use xlsReadWrite 1.5.2 (probably all
earlier versions also) you can download a quick fix, see below. I
don't know if this also affects
Natively read and write Excel (.xls) files. Supports Windows 32-bit only (atm).
A new version has been released:
-- changes --
o read.xls
- new arguments 'checkNames'
- recognize NA values according to a new 'naStrings' argument
- recognize NaN values
- recognize 'true', 'false' (not
or
library(xlsReadWrite)
write.xls(tab, somefile.xls) # not .xlsx
or lots of other possibilities (e.g. RODBC, RExcel, gdata, WriteXLS)
you would have found searching the mailling list archive or looking in
the R import/export manual or the R wiki...
Cheers,
Hans-Peter
2010/7/30 Dimitri Liakhovitski dimitri.liakhovit...@gmail.com:
I've wasted a lot of time trying to read in dates from Excel. Even
importing .csv files has not guarantees and often produces garbage
instead of dates.
What I found works best is saving the Excel data base as a
tab-delimited file
2010/7/30 rajibshibly rajibshi...@yahoo.com:
I am trying to read an Excel file using the following:
a-read.xls(mydata.xls, sheet=1)
[snip]
Error in findPerl(verbose = verbose) :
perl executable not found. Use perl= argument to specify the correct path.
Error in file.exists(tfn) : invalid
I am aware of the various packages (xlsReadWrite, RODBC) to get data
frames into R, but I would like to copy images too.
The xlsReadWritePro version could do it (see code below). It's a
shareware package, but if people need/ask for a gratis license I send
it (please download and check ?xls.lic
Many thanks! The missing empty line was the problem, and M-q works great.
Hans-Peter
Esc-q or M-q will wrap a whole paragraph. The only problem is that you need
to make sure the paragraph you want to wrap is separated from other
__
(emacs newb here)
After having made some changes in an \items paragraph of \arguments
the lines are no longer nicely wrapped. I was looking for a command to
reindent/rewrap/reformat the whole \items paragraph but couldn't find
anything.
The only way, I found, was to go to the end of the first
Hi, all. I too got this error, and when I went to register the correct DLL
(thinking the one downloaded but not installed might have been the
development version) I got an error that the registration had failed.
What I typed:
C:\Program Files\R\R-2.10.0\library\xlsReadWrite\libsregsvr32
2010/2/11 david.luck...@industry.nsw.gov.au:
Does anyone have a work-around for a failed installation of this package?
library(xlsReadWrite)
...
xls.getshlib()
However, the xls.getshlib() command fails with this error:
(For the record) It probably was a corporate firewall problem.
Apart
Jens,
2009/11/23 koj jens.k...@gmx.li:
library(xlsReadWrite)
Everything is fine, but the format of the export is not the best. For
example, I every time have to adjust the column width. Furthermore there is
no possibility to highlight some cell or make them colourful.
Auto-col is supported
2009/11/24 Kevin Wright kw.s...@gmail.com:
If had done a little searching before posting, you surely would have found
this link
https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html
which describes how to create .xls files that are customized any way that
you desire.
Manually convert
Marc -
I thank you for the links and ideas. Thanks to your advice I will look more
into SVN in the future, although it sounds on the surface to require some
learning curve, so It could take me some time to start using it.
If you consider investing time to learn a version control system, I
Also - is there a better way for the future? I know some people use IDE's
but is that for serious programming or for building a small function and
tweaking it?
What about a version control system to (locally) save the different
stages of your script files?
(I use git but Subversion (SVN) may
what happened to the xlsReadWrite package?
[snip]
Are there any plans for it be available again?
Yes. (I do have a halfway finished version but then had much work on
my regular job, my 'free-programming-time' got eaten by a e-texteditor
plugin
2009/7/2 Chris Anderson chris6...@netzero.net:
Is there a way to export multiple datasets into multiple excel spreadsheets
using xlsReadWritePro or with xlsReadWrite?
I have answered the question in your other thread. See:
http://thread.gmane.org/gmane.comp.lang.r.general/154614/focus=154752
I’m trying to export a file from R to excel using the xlsReadWritePro
function and I keep getting the error below.
POSIXt is not currently supported (neither in data.frames nor vectors)
and must be converted to other types (see ?write.xls). I almost never
use POSIXlt/ct myself but it would
I was using older version of R (installed early). I install new version of R
(R.2.9.0) but i could not find package xlsReadWrite to read Excel file.
As others have pointed out (thanks) you can find it here:
http://treetron.googlepages.com/.
It runs fine in 2.9.0.
Is there any alternatives to
Arg, I already needed to fix the bundle. If anyone downloaded it
yesterday, please update, the help index building was broken (on
Macs). Should work now.
Repo/Infos: http://github.com/swissr/rmate.tmbundle/tree/master
--
Regards,
Hans-Peter
__
I have uploaded RMate to Github. From the readme:
RMate is a [TextMate](http://macromates.com/) bundle for
[R](http://www.r-project.org/about.html). It is based on the [R/R
Console/Rdaemon](http://svn.textmate.org/trunk/Bundles) bundles and is
focused on:
- easy to use, clear interface/menu
-
2009/5/28 Dieter Menne dieter.me...@menne-biomed.de:
If you only have the sheet names, you should use package xlsReadWrite which
is rather fast, but has some limitations in the non-commercial version.
what limitations, i.e. features do you miss?
Cheers,
Hans-Peter
want an analysis. The best case were a surface of e.g. 8 Buttons, each click
leads to start a specific R file. My outputs are JPEG or CSV, so I don`t
need the output inside of R. Could anyone can give me some recommendations,
what could be a solution (e. g. Java)? Is such a solution possible?
rename(x,C,Z)
x - rename(x,C,Z)
x
A B Z D
1 2 3 4
--
Regards,
Hans-Peter
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide
2009/3/19 Pascal Candolfi pcando...@gmail.com:
Any idea why this library was removed and where could I find it for Windows
(only Unix in the Archive) ?
As indicated it was for for the binary (non FOSS) component.
Yesterday I checked the existing packages (xlsReadWrite(Pro) on
2009/3/15 David Scott d.sc...@auckland.ac.nz:
On Sat, 14 Mar 2009, Mathew, Abraham T wrote:
[snip]
Just checking on CRAN xlsReadWrite is not currently available. There is an
archived version available however.
Thanks for mentioning.
The reason is that CRAN is strict(er) now with binary
2009/3/9 Phil Spector spec...@stat.berkeley.edu:
The xlsReadWrite package provides write.xls for Windows,
but it cannot write _multiple_ spreadsheets
--
Regards,
Hans-Peter
__
R-help@r-project.org mailing list
2009/3/2 Prof Brian Ripley rip...@stats.ox.ac.uk:
The CRAN Windows ones. It is a windows-only package, see
http://cran.r-project.org/web/packages/xlsReadWrite/index.html
(incidentally to you: it seems no longer maintained and does not build under
R-devel on Windows, see
Excel stores times of the day as fractions of a day so I wrote a function to
convert the fraction to a number of seconds, extract the hours, minutes and
seconds and output it in ISO standard format (%H:%M:%S).
What about the 'colClasses' or 'dateTimeAs' argument in 'read.xls'
which gives back
I read data from *.xls file and i did some caliculations on that data and
now i have to create a column in the same .xls file
i tried it with *write.xls() *but the thing is it deleted all the columns
previously presented in that file and it created a column and inserted data
can any one
On an (Intel Leopard) Mac I try to build a package (mxFinance) which
depends on another package (mxGraphics). The dependendy is 1) a
'Depends:' in DESCRIPTION and 2) an import in NAMESPACE.
- The build fails if the dependent package (mxGraphics) is not
installed in the R.framework
Do I need to
Thanks for the answers,
but I'm looking for an editor like Tinn-R.
What about VM Fusion and continue to use Tinn-R then?
--
Regards,
Hans-Peter
PS: I use TextMate (and like it)
__
R-help@r-project.org mailing list
40 matches
Mail list logo