As mentioned by Fung in issue #7486 - \csv2excel command known problems:
Maximum number of rows per page:
> cat csv100K.txt | csv2excel -t 2003 > tmp.xls
> cat csv100K.txt | csv2excel -t 2007 > tmp.xlsx
Excel 2003 has a 65536 rows/page limitation; in the first example above, the input file contains 100K+1 rows, the output file will only have 65536 rows. Excel 2007 does not have this limitation as shown in the second example.For Excel 2003, enhancement likely can be made so that multiple spread sheet pages can be generated if the input CSV file contains more than 65536 rows. The Aspose API we currently use does not support this sort of configuration.
Or if the mentioned creation of multiple sheet pages cannot be achieved, the truncation of the data from the given file should be noted as an error message or in the manual.
We need to evaluate on whether we want to support pagination.
> We need to evaluate on whether we want to support pagination.
We should be able to support this without too much effort.
> We need to evaluate on whether we want to support pagination.
We should be able to support this without too much effort.
Both Excel 2003/2007 have limitation on worksheet size, see links below for more info:
2003 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
2007 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx
The following is added to the \csv2excel man page in the NOTES section:
In Excel 2003, the maximum worksheet size is 65,536 rows by 256 columns. In Excel 2007, the maximum worksheet size is 1,048,576 rows by 16,384 columns. If the number of CSV rows exceeds worksheet size, multiple worksheets are created. If the number of CSV columns exceeds worksheet size, those columns that go beyond the limitation are dropped.
Both Excel 2003/2007 have limitation on worksheet size, see links below for more info:
2003 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
2007 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx
The following is added to the \csv2excel man page in the NOTES section:
In Excel 2003, the maximum worksheet size is 65,536 rows by 256 columns. In Excel 2007, the maximum worksheet size is 1,048,576 rows by 16,384 columns. If the number of CSV rows exceeds worksheet size, multiple worksheets are created. If the number of CSV columns exceeds worksheet size, those columns that go beyond the limitation are dropped.
Verified in 12.0.3-7. Asked Jonathan to update wiki books as well
Verified in 12.0.3-7. Asked Jonathan to update wiki books as well
Issue #7812 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/29914 |
No time estimate |
1 issue link |
relates to #7486
Issue #7486\csv2excel command known problems |
We need to evaluate on whether we want to support pagination.