I am writing an CSV_to_Excel script for my wife. In the process she wants me to open an existing Excel file, add the CSV data, and save a new Excel file with all of the data in it.

I am using Text::CSV_XS, Spreadsheet::ParseExcel and Spreadsheet::WriteExcel.

The problem is in the existing excel file. The data in the cells has information like

=56.43+45.31+34.41

I want to take the CSV value (i.e. 99.99) and just append it to get the following:

=56.43+45.31+34.41+99.99

When I get the cell's value from Spreadsheet::ParseExcel I get the result (136.15). I can add 99.99 to it but that isn't the goal (and you're welcome to argue with my wife about the reasoning of keeping those original values but you will not get anywhere ;-). Is there a way to get that original value and append a new value?

I read that ParseExcel only reads the results so I am open to any suggestions.

On a side note, I am using OpenOffice.org to view the Excel files and I am trusting that it is accurate.

-- rogueFalcon
Why do you people insist on doing things sdrawkcab? RogueFalcon.com

In reply to CSV to Excel (where I keep the excel formula) by rogueFalcon

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.