Dear Monks,

For a cgi application on a unix box, I want to open an existing Excel spreadsheet that's sitting on the server, write new data to one of the worksheets, and download the updated file to the user.

We have successfully created and downloaded new Excel workbooks using Spreadsheet::WriteExcel (a most excellent module). But, perusing the Spreadsheet::WriteExcel documentation, we can find no open() or similar command. Worse, we've found articles on other developpers' sites stating flatly that you can't do this with Spreadsheet::WriteExcel - the best you can do is parse an existing file to get cell values, but formatting and formulas are lost. As the whole purpose of the other worksheets in this file is to calculate tables and generate graphical charts based on the first sheet's values, losing formulas is not an option.

So, this is my last shot - does anyone out there have knowledge of how to do this, knowledge that would have escaped the documentation and other developers?

Thanks.

20031224 Edit by BazB: Changed title from 'Spreadsheet::WriteExcel'

In reply to 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.