Page 1 of 1
First Benchmarks with XLS versus XLSX in XLSREadWrite2 4.0
Posted: Sun May 11, 2008 7:48 pm
by 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
Posted: Tue May 13, 2008 3:11 pm
by 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
Comparision xls-xlsx in Excel2007
Posted: Wed May 14, 2008 6:04 am
by 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
Posted: Sat Nov 08, 2008 5:51 pm
by 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!!!
Posted: Sat Nov 08, 2008 6:54 pm
by 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.
Posted: Sat Nov 08, 2008 10:40 pm
by Wild User
larsa wrote:This problem was fixed in update 4.00.07
I test in version 4.00.08...
Posted: Sun Nov 09, 2008 1:08 pm
by 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.
Posted: Sun Nov 09, 2008 3:06 pm
by 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
Posted: Thu Nov 13, 2008 8:29 pm
by 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
Posted: Sun Nov 16, 2008 8:59 pm
by 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...
