First Benchmarks with XLS versus XLSX in XLSREadWrite2 4.0

[PStadler]

Hello,

I have done first benchmarks with an Excel-File containing 10000 lines
in comparison with an XLSX-File, also 10000 lines. Tests have been performed with PaintCell-Example. Size is Excel-Size, Office 2007.

xls xlsx
Size 5.039MB 2.530MB
loadTime 1sec 20sec
Memory 46028 MB 596680 MB

So the xlsx-Version is 20 times slower in PaintCell and more than 10 times bigger.

I hope an optimization can be done.

Sincerely Peter

[larsa]

Hello

The read/write speed will never be as good as the binary file formats. This is also true for excel itself. The memory consumption is more strange. It should be more or less the same amount as the size of the disk file.

Lars Arvidsson, Axolot Data

[PStadler]

Hello,

If I load a very large Excel-File (200.000 lines in several sheets) at first as xls in Excel 2007
then it takes about 5 seconds. If I do it with the same xlsx-file, it will take
about 28 seconds. So the factor is about 4 in Excel, but never 20 as in the PaintCell example!!!

Sincerely

Peter

[Wild User]

Hi!
Yes, i have this problem too:
File xls (text in cells only, 1100 rows/12 cols, 368 kb) -> open ~1-2 sec
File xlsx (text in cells only, 1100 rows/12 cols, 155 kb) -> open ~5 min!!!

[larsa]

Hello

This problem was fixed in update 4.00.07 When I test a file with 1100 rows and 12 cols, it takes about one second to read it.

[Wild User]

This problem was fixed in update 4.00.07

I test in version 4.00.08...

[larsa]

Hello

Are you sure that you have the latest version installed? Check the ComponentVersion property. If the version is correct, please send me the file, and I'll will check it.

[Wild User]

Hello!

Check the ComponentVersion property

I check it - 4.00.08

I tested also the new version (4.00.10), but have removed it - error at reading a file.
If reading one file - it is good, if to load other file (after) -

"List index of bounds"

With version 4.00.08 of such error is not occured.
Version 4.00.10 too reads a xlsx-file more slowly than xls-file...

please send me the file

OK. It is sent.

Excuse for my bad English

[larsa]

Hello

I got your file, and it take about one second to read it. Please also download update 4.00.11 as there may have been a problem with 4.00.10

[Wild User]

Please also download update 4.00.11

Download version for D7... Install... -> I see in inspector version 4.00.10a... Earlier it has been installed v 4.00.08
OK... Read... Result: xlsx-file ~5 min...
I can't understand in what a problem...