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

2011-07-13 Thread syrvn
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 trying to write the data frames to the excel sheets: Error

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

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 get

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

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 ment...@gmx.net 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

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

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

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