Re: [R] WriteXLS problem

2010-09-07 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 number of

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:

[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

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,

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

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

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 Cabrera

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 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 file