Think about Loose Coupling | |
PerlMonks |
Re: Read Excel cell comments?by misterwhipple (Monk) |
on Apr 02, 2007 at 14:56 UTC ( [id://607840]=note: print w/replies, xml ) | Need Help?? |
You could try opening the spreadsheet with Excel, and saving it as an XML spreadsheet. The XML should be much easier to parse.
I just did a test using Excel 2003, and the cell comments are preserved. Here is the relevant portion of the XML. (I've changed the whitespace and removed font tags for clarity)
If you have an inconveniently large number of spreadsheets to work with, perhaps you could use OLE to automate the conversion to XML.
cat >~/.sig </dev/interesting
In Section
Seekers of Perl Wisdom
|
|