Oct 18, 2012, 3:32 PM
Post #2 of 6
My comment may be outdated, but last time I looked at the Excel Perl modules, it was apparently not possibe to edit an existing Excel file. You could:
Re: [gigaaks] Update an excel file on sharepoint via Perl script
[In reply to]
- read an existing Excel file
- write a new fresh Excel file
- but not modify an existing Excel file (because,, as far as I remember, of proprietary CRC types of checks added by Microsoft to Excel files).
You still have the option of reading the content of an Excel file and insert its modified content to another file, and then do the necessary house cleaning (deleting old file and renaming the new one).
Please anyone correct me if I am wrong, what I am saying here dates from four or five years ago, it might have changed since and I might have got it wrong or not used the right modules at the time.