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. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.