Oct 22, 2010 at 9:39 AM
Edited Oct 22, 2010 at 9:40 AM
- add one worksheet, than write file, destroy phpexcel object.
- reopen file, add another worksheet, etc....
this solution doesn't work , since the previous worksheets will get deleted
meaning if file "abcd.xlsx" had "sheet 1" , "sheet 2"
and creating a new workbook with "sheet 3" and writing it to "abcd.xlsx" will results in only "sheet 3" while "sheet 1" and "sheet 2" are lost
my purpose is this :
suppose each sheet had 1000 lines , then on each run i don't want to load and write all sheets since it will
results in loading n*1000 lines and saving them , instead i only want to create a new
sheet with 1000 lines and append it to the existing file making it with (n+1)*1000 lines
it should be clear that much performance is reduced by this procedure
if i want to only append new 1000 lines to excel , why should i load the whole n*1000 lines previously created ?