Spreadsheet BIFF help

guyverlord3 has asked for the wisdom of the Perl Monks concerning the following question:

I have been working on making my manager really happy. So I have been writing something to do create an excel spreadsheet with all sorts of pretty graphs and such. While testing my program I notcied that with does not work with surtain Doc Interps on cell phones. After doing some poking around I found the reason is because spreadsheet is using BIFF 5, and the programs are expecting BIFF 8. Is there anyway to get Perl to do that, or should I move to .NET to get this done.

Comment on Spreadsheet BIFF help

Replies are listed 'Best First'.
Re: Spreadsheet BIFF help by Corion (Patriarch) on Jun 03, 2008 at 12:38 UTC
I'm really unclear what you mean by "Doc Interps", and also what you mean by "spreadsheet is using BIFF 5". I interpret your question as follows: You're using Spreadsheet::WriteExcel to create Excel format files. Some mobile Excel document display programs are having problems with some of the produced files because the files seem to be in the BIFF 5 format while the programs seem to expect BIFF 8 format. If you want to produce BIFF 8 format, I guess the easiest way is to automate Microsoft Excel to produce them. See Win32::OLE and lots and lots of examples here, via Super Search.	[reply]
Re: Spreadsheet BIFF help by jmcnamara (Monsignor) on Jun 04, 2008 at 00:43 UTC
Spreadsheet::WriteExcel produces Excel files in BIFF8 format. If you are targeting a mobile device you should also turn on WriteExcel's compatibility_mode() -- John.	[reply]