Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread David Winsemius
On Jul 13, 2011, at 11:49 AM, David Winsemius wrote: In particular: The xls.write function in gdata uses Perl. Wrong name I was thinking of read.xls in gdata. David Winsemius, MD West Hartford, CT __ R-help@r-project.org mailing list ht

Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread David Winsemius
On Jul 13, 2011, at 9:14 AM, syrvn wrote: Hi, thanks for this web page! Grothendieck had offered: - There are quite a few approaches listed here: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows - We decided to go for XLConnect because it can read and write xlsx she

Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread syrvn
Hi, thanks for this web page! We decided to go for XLConnect because it can read and write xlsx sheets. With that package we get the same error message (see above) as with the xlsx package. After that error we even end up with a corrupted excel spread sheet. We are not able to open it any longer

Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread Gabor Grothendieck
On Wed, Jul 13, 2011 at 5:46 AM, syrvn wrote: > Dear group, > > I am working on a rather big project where the output data frames have > dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the > data.frames to Excel sheets. > > Since recently we get the following error, when t

Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread syrvn
Hi Denis, are you saying that we should write the R output (data frame) to a .csv file and then import it manually into Excel? Thanks Flo -- View this message in context: http://r.789695.n4.nabble.com/Error-when-writing-to-Excel-files-using-the-packages-xlsx-and-xlsx2-tp3664617p3664639.html Sen

Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread Denis Kazakiewicz
write.csv(mydata, file="mydataExported.csv", na="") On 13.07.2011 12:46, syrvn wrote: Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we

Re: [R] Error when writing to Excel files using the packages xlsx and xlsx2

2011-07-13 Thread Denis Kazakiewicz
The most safe way work with excel is through .csv format Sorry for being nonspecific On 13.07.2011 12:46, syrvn wrote: Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to E