in reply to Read Excel cell comments?

Depending on how much time and energy you want to put into this, one option might be to write a program to extract the comments yourself from a version of the Excel file saved as HTML. This is probably easier than attempting to extract the comments from the .xls file.

Otherwise, I'd look for ways to speed up the OLE version. Maybe you can use ParseExcel to get cell values and use OLE to extract the comments?

Replies are listed 'Best First'.
Re^2: Read Excel cell comments?
by AlwaysLearning (Sexton) on Apr 03, 2007 at 03:56 UTC
    Yeah, the hybrid approach might be workable... too bad ParseExcel doesn't seem to read cell comments... I'll have to see how much time it saves vs using OLE for everything.
[reply]
      OK, the hybrid approach saves 1/2 the time.

      Sure wish ParseExcel would read comments, that would save the 90% of the rest of the time, I suspect...

[reply]

In Section Seekers of Perl Wisdom