Re: Excel changes?

You're not setting any formats ... formats in Spreadsheet::SimpleExcel are on a per-worksheet basis, as seen in the POD for set_data_format().

In Spreadsheet::WriteExcel, formats are on a workbook-wide basis. (Same with Excel::Template, which may be a good choice for you.)

Comment on Re: Excel changes?

Replies are listed 'Best First'.
Re^2: Excel changes? by samizdat (Vicar) on Apr 21, 2005 at 15:21 UTC
Okay, my bad. I thought that Excel would globalize things. Thanks, dragonchild! :D	[reply]
Re^3: Excel changes? by dragonchild (Archbishop) on Apr 21, 2005 at 15:25 UTC
Excel DWIMs, but the XLS file format does not. True to the format, Spreadsheet::WriteExcel will let you recreate the same cell format over and over, which may become a problem as there is a finite limit on the number of formats a given XLS file will allow. Various modules that wrap around Spreadsheet::WriteExcel may or may not do the right thing. For example, it took 6 months and three programmers to do it right in Excel::Template. My wife's blog	[reply]