The following table describes speed tests of OLE XLSFile library.
Note that OLE XLSFile 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
1.02
49 000
Write an MS Excel file with 50 000 cells
with random text values of length 10-60 characters
1.36
36 700
Write an MS Excel file with 50 000 cells
with random integer values
0.75
66 666
Write an MS Excel file with 6 000 rows having 30 columns
(180 000 cells) with different data:
2 columns of random text, 4 columns of constant text,
and 24 columns of random integers.
