Is anyone interested in helping improve the charting functionality of the Spreadsheet::WriteExcel module?

For those that haven't tried it, the current functionality requires you to create a chart in Excel (or oocalc, etc), then save the .xls and use an external utility 'chartex' to extract the binary chart data. Most of the attributes of the chart including the data range selections are frozen when the extract is done.

I've been working on a module to generate chart data on the fly. The code is of course buggy and many things aren't yet implemented, but it can already generate simple variants of some of the basic chart types supported by oocalc (Column, Bar, Line, etc).

I'd welcome help if anyone is interested. I've corresponded with John McNamara who is the maintainer of Spreadsheet::WriteExcel and it is possible that this code may eventually be integrated in once it is more mature, documented, tested, etc.

In reply to Charting with Spreadsheet::WriteExcel by softwarejanitor

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.