|Just another Perl shrine|
Writing Excel Spreadsheets -- suggestions soughtby blue_cowdawg (Monsignor)
|on Sep 13, 2013 at 13:34 UTC||Need Help??|
blue_cowdawg has asked for the
wisdom of the Perl Monks concerning the following question:
I recently inherited the dubious honor of being the email delivery police for my company. One of my roles within that is dealing with clients of ours whos email jobs result in UCBE complaints being filed.
This is the facet of the job I take most seriously. Our remailer service is not supposed to be used for UCBE but every once in a while we have a client that doesn't play by the rules and that's where I get involved.
In order to get the client "dealt with" I have to be able to build a case with management and show real data. To that end I am writing an automated solution to collect the complaint data and convert it to a spreadsheet (management loves spreadsheets) along with charts and graphs (they love them even more) and provide the spreadsheets in an email. A weekly report of sorts. </p.
I have 99% of this figured out and working. The last 1% is bugging the hell out of me and I'd like some suggestions on how to solve the issues.
I use SpreadSheet::Excel to generate my spreadsheets and have for years. The one thing I've never been able to figure out is how to auto size the columns. I take a SWAG and just hard set the width which mostly works but occasionally I have to go in and hand tweak the widths before sending the spreadsheet out. I don't want to do that any more.
I'm hoping to eventually take myself out of the picture so far as the reports go and they'll get delivered even when I'm on vacation, out sicke, feeling lazy or whatever.
Peter L. Berghold -- Unix Professional
Peter -at- Berghold -dot- Net; AOL IM redcowdawg Yahoo IM: blue_cowdawg