Hi!

I would like to read an xls worksheet, edit some data, and write it again, but without removing the source of formulas. I have not found any possibility to get them. I also tried to find something like this in Perls CPAN-Modules, but there it is not possible, too. I do not really need the formula itself, I only want to edit data form en excel-sheet, and formulas (not only the result of formulas!) should just stay there as they are.

I found two postings about the perl-modules (which also cannot do this, yet):

http://groups.google.de/groups?selm=3e46e6c3.7398322%40news1.eircom.net

http://groups.google.de/groups?selm=8cceb2da.0408271508.33606865%40posting.google.com

Do you think this could be realized with PHP-ExcelReader and PEAR::Spreadsheet_Excel_Writer?

Or does someone now some details how something like this could be realized, or what needs to be done to PHP-ExcelReader / PEAR::Spreadsheet_Excel_Writer to make this work?

kind regards,

Andreas