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

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.
  • Hi,

    Have you seen Spreadsheet::WriteExcelXML [cpan.org]? If there are some Excel features missing that you want to use, it might be better to hack on this module and send patches to the author rather than starting a new module from scratch.

    Cheers,

    JJ

  • I think you should look more closely at Spreadsheet::WriteExcel before cranking up a new project: it can certainly do some of the things that you claim it lacks. For example, to write an internal link (to a sheet called $s_name using format $format)...

    my $contents = $ss->sheets(0);
    $contents->write($row,$col,"internal:$s_name!A1",$s_name,$forma t);

    It can also write simple formulas with ease (see the documentation). Pivot tables and autofilter aren't available however (the latter is on the TODO list), un
  • I would highly recommend working with John McNamara to improve one of the existing modules, rather than reinventing the wheel just to put on white walls. He is one of the good ones.

    I know it can be frustrating to find a feature missing or implemented inconveniently in a module, but if you branch or reinvent, take a look at the mail list to see what you are taking on! Even a branching would introduce such version skew to keep up with, my God!