Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re: Writing Excel Spreadsheets -- suggestions sought

by dasgar (Priest)
on Sep 13, 2013 at 15:40 UTC ( #1053959=note: print w/replies, xml ) Need Help??

in reply to Writing Excel Spreadsheets -- suggestions sought

Not sure if this is necessarily a "good" suggestion, but I'll toss it out anyways.

I'm assuming that when you "hand tweak the widths" that you're doing so on a Windows system that has Excel. Working off that assumption, here's one crazy (and maybe extreme) idea:

  • Have your current script put the Excel file on a network share and not do the automated email.
  • From a Windows system that has Excel installed and access to the network share from the previous step, have a script that goes opens the Excel file from that share and uses Win32::OLE to handle all of the autofit stuff. You should be able to use task scheduler to configure this script to run at a specific time each week.
  • Then have yet a third script that would handle the emailing of the finalized Excel file.

If having a Windows box with Excel to handle the autofit stuff is not a viable solution for you, perhaps you can look into using OpenOffice or LibreOffice and automate the autofit through their API - similar to using Win32::OLE to automate Excel.

I'll admit my ideas probably are a bit crazy and extreme, but thought I'd toss them out in case it proves useful or might give someone an idea for a better solution.

  • Comment on Re: Writing Excel Spreadsheets -- suggestions sought

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1053959]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (7)
As of 2018-04-21 21:23 GMT
Find Nodes?
    Voting Booth?