Hi,
I can't comment directly on the packages but perhaps your Excel Spreadsheet approach can be modified to make your life a lot easier?

Why don't you simply separate the two items? Data (your values) in one Workbook and the formulae/charts in another.

Using this approach you can happily (?) use Spreadsheet::ParseExcel to read the spreadsheet and Spreadsheet::WriteExcel to spit it back out with the new numbers... the linked spreadsheet isn't getting modified and as long as you can ensure that the filename is preserved (i.e. you don't clobber the file as someone opens the other workbook - Excel might not like that) everything should be ok.

Alternatively, store your values in a CSV format file(s) and write an Auto_Open macro in your main spreadsheet to import the values into 'named ranges' in your spreadsheet - this saves worrying about "Update Links" messages. Then you have to worry about how 'fresh' the data is.

Your approach will depend on how often the data is modified, I guess...

HTH - Mark

In reply to Re: Preserving metadata when processing Excel file by maa
in thread Preserving metadata when processing Excel file by punchcard_don

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.