Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

djberg96 (2603)

djberg96
  (email not shown publicly)

Journal of djberg96 (2603)

Friday August 23, 2002
02:21 PM

Spreadsheet port - decisions

[ #7268 ]
Today as I was going over some of the links that John kindly providing regarding Excel development, I decided to take a step back in my whole approach.

First, as you may or may not know, Spreadsheet::WriteExcel currently uses the BIFF5 format (i.e. Office 95 & earlier). For Excel 97 & later, they use BIFF8 (or BIFF8x for XP). After thinking about this a bit, I've decided not to do a straight port of John's module, but rather to (foolishly?) attempt to start with BIFF8 support from the get go.

Actually, I think I'm going to layout each BIFF format as its own class, starting with BIFF8, and adding BIFF5 and BIFF8x as time goes on. I don't think there's any need to support BIFF2 or BIFF4 these days, but I could be wrong, and they can always be added as their own classes later (in my fantasy world, anyway).

Another huge can of worms is that there is no pure Ruby recursive descent parser (used for formulas), though there extensions for lex, yacc and bison. On top of that, I know next to nothing about parsers in general.

The pain, the pain!

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.