search for: modifying_and_rewriting_excel_files

...obust option via Perl. The combination of the required Perl packages Spreadsheet::ParseExcel and Spreadsheet::WriteExcel does not support the preservation of many pre-existing worksheet objects as noted in: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES These include embedded graphics, cell formulae, macros, etc. which would be lost during the worksheet appending process. Via Perl, it appears that one cannot simply open an XLS file, add a new worksheet and then close the file. One has to open the existing file, read each existing worksheet, write...

...obust option via Perl. The combination of the required Perl packages Spreadsheet::ParseExcel and Spreadsheet::WriteExcel does not support the preservation of many pre-existing worksheet objects as noted in: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#MODIFYING_AND_REWRITING_EXCEL_FILES These include embedded graphics, cell formulae, macros, etc. which would be lost during the worksheet appending process. Via Perl, it appears that one cannot simply open an XLS file, add a new worksheet and then close the file. One has to open the existing file, read each existing worksheet, write...