[Pharo-project] Is there any package to manipulate excel files?
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?
More information about the Pharo-project