Re: [R] WriteXLS problem

2010-09-07 Thread Marc Schwartz
Hi, Apologies for coming to this thread late, but I just got the posts early this morning, so there was a delay in receipt for some reason. As per the other comments, there is a limit in Excel 2003 of 64k rows and as far as I can tell from MS' own specs, that has not changed: http://office.

Re: [R] WriteXLS problem

2010-09-06 Thread Kenneth Roy Cabrera Torres
Dears Dejian and David: Thank you for your help. Maybe dataframes2xls package have the same problem. But "xlsx" take too much time to write it down. Kenneth. El lun, 06-09-2010 a las 20:56 -0400, David Winsemius escribió: > On Sep 6, 2010, at 8:09 PM, Dejian Zhao wrote: > > > The maximum numb

Re: [R] WriteXLS problem

2010-09-06 Thread David Winsemius
On Sep 6, 2010, at 8:09 PM, Dejian Zhao wrote: The maximum number of rows in excel 2003 or below is 65535, less than your number of rows, so if you export your data into "xls" files, probably you cannot see all your data in excel. Exel 2007 can hold as many as 1048575 lines, thus "xlsx" fi

Re: [R] WriteXLS problem

2010-09-06 Thread Dejian Zhao
The maximum number of rows in excel 2003 or below is 65535, less than your number of rows, so if you export your data into "xls" files, probably you cannot see all your data in excel. Exel 2007 can hold as many as 1048575 lines, thus "xlsx" file is a better choice. On 2010-9-7 0:03, Kenneth

Re: [R] WriteXLS problem

2010-09-06 Thread Kenneth Roy Cabrera Torres
I use the following sintaxis for the packages: For WriteXLS I use: writeXLS(todo2009,"todo2009.xls") And for dataframes2xls I use: dataframe2xls::write.xls(todo2009,"todo2009.xls") El lun, 06-09-2010 a las 12:34 -0400, David Winsemius escribió: > On Sep 6, 2010, at 12:25 PM, Kenneth Roy Cabre

Re: [R] WriteXLS problem

2010-09-06 Thread David Winsemius
On Sep 6, 2010, at 12:25 PM, Kenneth Roy Cabrera Torres wrote: Thank you Ivan for you answer: El lun, 06-09-2010 a las 18:11 +0200, Ivan Calandra escribió: Hi, Are you sure you used the correct syntax and object names? It might just be because of that...(reading the error messages) Im sur

Re: [R] WriteXLS problem

2010-09-06 Thread Kenneth Roy Cabrera Torres
Thank you Ivan for you answer: El lun, 06-09-2010 a las 18:11 +0200, Ivan Calandra escribió: > Hi, > > Are you sure you used the correct syntax and object names? It might just > be because of that...(reading the error messages) Im sure, because it works with write.csv or write.table. > There is a

Re: [R] WriteXLS problem

2010-09-06 Thread Ivan Calandra
Hi, Are you sure you used the correct syntax and object names? It might just be because of that...(reading the error messages) There is another function, xlsReadWrite::write.xls(), that I like a lot: it is really easy to use and does not require Perl or Python. HTH, Ivan Le 9/6/2010 18:03, K

[R] WriteXLS problem

2010-09-06 Thread Kenneth Roy Cabrera Torres
Hi R users: I don't know if you have had the following problem trying to export to an "xls" format file in a non windows platform. I try to use the following packages: 1. dataframes2xls (version 0.4.4) (with phyton 2.7 and 3.1) 2. WriteXLS (version 1.9.0) (with perl and testPerl working) Even "x