Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Writing Excel Spreadsheets -- suggestions sought

by Albannach (Prior)
on Sep 13, 2013 at 21:35 UTC ( #1054019=note: print w/ replies, xml ) Need Help??


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.

The downside is depending on your users' setups they may have to authorize the macro to run when they load the file, which may generate lots of questions and put you no farther ahead than you are now.

--
I'd like to be able to assign to an luser


Comment on Re: Writing Excel Spreadsheets -- suggestions sought
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1054019]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2014-07-12 13:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (240 votes), past polls