[EMAIL PROTECTED] wrote:
I need to be able to create Microsoft Excel files from a perl script. I want to know which module for doing this that people recommend. I don't need anything too fancy. There will be very little formatting. What formatting I need to do will be column widths and maybe bold and/or underline. I also need to be able to use formulas. Which module do people recommend?
Hi,
I just wrote a script for use with Excel from a database. It writes a csv compliant file. My needs were simple for this particular file so I chose simple methods. I used the column list construct so that I could correctly order the output from the hash, that might be overkill, but I still needed the list of columns so that I could output them a column headers for the spreadsheet. There are modules out there that will give you a much broader range of features as well as an api to work with them. But for quick and dirty, this works fine.
I considered just using CSV, but there are non-technical reasons why I didn't. If I write it to a file called something.csv, Excel can open it just fine and not complain. The problem is that the people who are going to be using these spreadsheets will be very confused when Excel starts popping up messages about converting to .xls format from CSV if they make changes, add formatting, etc.
-- Andrew Gaffney
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
