The following table describes speed tests of TXLSFile library.
Note that TXLSFile is based on direct reading and writing
of Excel files. It does not use or require Microsoft Excel, and lets you bypass OLE Automation.
Hardware used for tests
CPU: 3.2 GHz
Memory: 1 Gb
System: Microsoft Windows XP
Result
Test description
Average test time (seconds)
Average cells/second
Write an MS Excel file with 50 000 cells
with the same text value
0.78
64 100
Write an MS Excel file with 50 000 cells
with random text values of length 10-60 characters
1.14
43 800
Write an MS Excel file with 50 000 cells
with random integer values
0.48
104 100
Write an MS Excel file with 6 000 rows X 30 columns
(180 000 cells) with different data:
2 columns of random text, 4 columns of constant text,
and 24 columns of random integers.
