in reply to Writing Excel Spreadsheets -- suggestions sought
Another potentially hair-brained scheme for your consideration:
- For a one time task using actual Excel, create a workbook with an Auto_Open() macro containing simply Columns.AutoFit
- Again one time only, using the extract_vba.pl utility from Excel::Writer::XLSX, extract the macro as a binary file and store it somewhere permanently for use in your periodic spreadsheet generation
- Use Excel::Writer::XLSX to do all your spreadsheet creation, and also insert the macro using add_vba_project( 'vbaProject.bin' ), then distribute the resulting as an XLSM file. Now I don't know how much this will mess up your spreadsheet creation code, but according to the docs, it should be little problem.
--
I'd like to be able to assign to an luser
In Section
Seekers of Perl Wisdom