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.
  • by pjm (639) on 2007.02.04 17:43 (#53036)
    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,$format);

    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), unless something's changed *very* recently.