[Pharo-project] Is there any package to manipulate excel files?

Yanni Chiu yanni at rogers.com
Mon Nov 1 20:37:45 CET 2010


On 01/11/10 11:08 AM, Guillermo Polito wrote:
> It is a bad an awful real excel file :(.

Excel also has an XML format. You may be able to manipulate it in this 
format. It takes some back & forth, but you can eventually figure out 
how changes to the XML affect the spreadsheet, and vice versa. I was 
able to create separate worksheets, and control column widths, in the 
XML I generated.

Can you get the Excel file saved in XML format, if you need to read it?
Excel is able to recognize some magic text at the start of the XML, so 
it has no problem reading such a file.

Is this a one time conversion, or will it be repeated in a workflow?

-- 
Yanni Chiu





More information about the Pharo-project mailing list