I've got some xlsx files to process both reading and writing.
The files contain about 10 sheets with 1000 rows * 30 columns = up to 300000 cells.
Each of the sheet has some cell style information like background color and also some
formula like sum and average inside.
My script is going to read the static data (only!), not the formula or styles. All I need, is the raw data for the reader.
The writer script is appending new data lines and does not touch the style or formula. Also static data, only, and no dynamic or styled content.
That's why I wonder if the style details and formula are slowing down the script though?
Currently I try optimization with the
- PHPExcel_Settings::CacheStorageMethod and
Is there something helpful to disregard the style information or something else to increase the speed of the reader and/or writer with XLSx?
Thanks for advice and kind regards,