From Spreadsheet::WriteExcel:
An Excel file is a binary file within a binary file. It contains several interlinked checksums and changing even one byte can cause it to become corrupted.
As such you cannot simply append or update an Excel file. The only way to achieve this is to read the entire file into memory, make the required changes or additions and then write the file out again.
This would suggest the easy answer to your question is no. Are you sure that the memory problems are coming from the module in question (Devel::Monitor)? Can you split your task into multiple files? Can you buy more memory or run on a machine with more?
As a side note, the program is 'perl' and the language is 'Perl'. There is no 'PERL'. | [reply] |
Alternatively you can save your data in comma- or tab-separated values format and use Excel to read that file and save it in its native format.
CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James
| [reply] |
| [reply] |