Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
February 18, 2010, 12:43 am
rate this thread
misc - this has got to be the place.
Sorry if this is outside the limits of a perl question, but has anyone
ever worked with HTML, preparing it for an Excel HTML import? We are
sending HTML to the client via
But the rendering in Excel is terrible. Is there a perl
ExcelPrepHTML.pm out there? I wish I knew more about the Excel import
rules, but I don't. Hoping someone else does; then stuck it all in a
I see some code out there that use OLE to manipulate the workbook, but
this is strictly a hand off.
The xlsx format is pure XML. This means that you can write a script
that generates ASCII and Excel 2007 will render it natively.
To see what I mean, take an Excel file, change the xlsx extension to a
zip extension, and then unzip the file.
Obviously, generating an Excel file this way is extremely difficult,
but it IS possible. Better IMO is to generate files in simple CSV
format which Excel also opens natively -- except that this excludes
formatting and formulas.
- » FAQ 2.14 Where are the archives for comp.lang.perl.misc?
- — Previous thread in » PERL Discussions