in reply to 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.)

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
      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.