Each time when I use PHPExcel to write a excel file ,I can’t make it additional but overwrite.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
April 21, 2011 12:37am
Subscribe [2]#1 / Apr 21, 2011 12:37am
Each time when I use PHPExcel to write a excel file ,I can’t make it additional but overwrite.
#2 / Apr 21, 2011 11:04am
Each time when I use PHPExcel to write a excel file ,I can’t make it additional but overwrite.
1.) Open the file
2.) Put all that info into an array
3.) Write array to either a new file or database as a backup or version control
4.) Add new info to that array where ever it needs to go using the appropriate array functions
5.) Re-write the file.
Right or wrong that’s what I do and it works. I see that PHPExcel has editing capabilities so there’s probably a more efficient way of doing it.
Ed
#3 / Apr 21, 2011 10:00pm
Each time when I use PHPExcel to write a excel file ,I can’t make it additional but overwrite.
1.) Open the file
2.) Put all that info into an array
3.) Write array to either a new file or database as a backup or version control
4.) Add new info to that array where ever it needs to go using the appropriate array functions
5.) Re-write the file.Right or wrong that’s what I do and it works. I see that PHPExcel has editing capabilities so there’s probably a more efficient way of doing it.
Ed
Any other ways?
I want to add new data to the Excel file, just as using PHPExcel to write this file cost nearly 300M memories , I think I can divide the file into several parts , then I can write these parts one by one.
But with your method，it is same as the previous.