Slow write
Posted: Wed Apr 04, 2007 7:28 am
I compile simple test program with demo-version 3.01.01a.
...
XLS.FileName := 'test.xls';
XLS.Read;
XLS.Write;
...
File size is > 1Mb, with 15 or more worksheets.
Read from file is very fast, < 1sec
Write to file is very-very-very slow, > 2min!!!
Why?
If file contains formulas in some cells, result file is corrupted, but opened Excel with warning "File data may be lost" (sorry traslate from Russian).
...
XLS.FileName := 'test.xls';
XLS.Read;
XLS.Write;
...
File size is > 1Mb, with 15 or more worksheets.
Read from file is very fast, < 1sec
Write to file is very-very-very slow, > 2min!!!
Why?
If file contains formulas in some cells, result file is corrupted, but opened Excel with warning "File data may be lost" (sorry traslate from Russian).