[R] WriteXLS problem

[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 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.
> 
> The maximum number of rows in more editions of Excel.2003 was  
> increased to a million. You may be correct about the Perl module that  
> underlies WriteXLS, however. Here is an extract from the CPAN page for  
> that module:
> 
> http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm#LIMITATIONS
> 
> LIMITATIONS
> The following limits are imposed by Excel:
> 
> Description Limit ----------------------------------- ------
>   Maximum number of chars in a string 32767
>   Maximum number of columns 256
>   Maximum number of rows 65536
>   Maximum chars in a sheet name 31
>   Maximum chars in a header/footer 254
> The minimum file size is 6K due to the OLE overhead. The maximum file  
> size is approximately 7MB (7087104 bytes) of BIFF data. This can be  
> extended by installing Takanori Kawai's OLE::Storage_Lite module http://search.cpan.org/search?dist=OLE-Storage_Lite 
>   see the bigfile.pl example in the examples directory of the distro.
>