× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
aquaclusters.josekibold reported 2012-10-17T16:57:29Z  · tariqrahiman last modified 2012-10-30T19:46:25Z

\csv2excel -t 2003 on converting more than 65536 rows/page


Dev
Fun Fun
funfun
QA
Niels Gron
NielsGron
Priority Minor
Complexity Unknown
Component App - FluidShell - Command
Version 12.0

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.

Issue #7812

Closed
Fixed
Resolved 2012-10-25T03:36:47Z
 
 
Completion
No due date
Fixed Build trunk/29914
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017