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 ]

tvmaly (7655)

tvmaly
  (email not shown publicly)

Journal of tvmaly (7655)

Saturday February 03, 2007
10:52 PM

WriteExcel for Excel 2003 XML

[ #32317 ]
I have been thinking about writing a new module to write Excel 2003 xml. The current module Spreadsheet::WriteExcel has is limitations. For instance, it lacks the ability to insert links to other sheets within the same workbook. It also lacks the ability to create pivot tables. I would like it to produce very minimal worksheets. However, I would like it to be able to add the auto filter, do some minimal styling, and have the ability to add basic formulas. I will be starting this project sometime next month when the workload slows up a little. Has anyone else given any thought to a project like this?
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!