|Syntactic Confectionery Delight|
CSV to Excel (where I keep the excel formula)by rogueFalcon (Beadle)
|on Sep 01, 2007 at 23:51 UTC||Need Help??|
rogueFalcon has asked for the
wisdom of the Perl Monks concerning the following question:
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
I want to take the CSV value (i.e. 99.99) and just append it to get the following:
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.