How to read cell comments from an xls?

Posted on 2008-11-07 07:45:49-08 by jrpathak

I am trying to read xls data along with cell comments. I am able to read all data except for any cell comments. I am trying to read data from Office 2003/7 on 32 bit Windows. Thanks in advance for your help. -Jitendra

Direct Responses: 9246 | Write a response

Posted on 2008-11-07 07:52:01-08 by jmcnamara in response to 9245

Re: How to read cell comments from an xls?

Unfortunately, that isn't currently possible with Spreadsheet::ParseExcel.

John.
--

Direct Responses: 9247 | Write a response

Posted on 2008-11-07 08:19:25-08 by jrpathak in response to 9246

Re: How to read cell comments from an xls?

Thanks John for the quick reply and the information! Is there any way I can use Perl to read those comments, btw?

Direct Responses: 9249 | Write a response

Posted on 2008-11-07 10:24:47-08 by jmcnamara in response to 9247

Re: How to read cell comments from an xls?

You could probably do it on Windows with Win32::OLE and Excel. I don't have an example however.

This feature may be added to ParseExcel in a future release but I cannot make any promises.

John.
--

Direct Responses: 9250 | Write a response

Posted on 2008-11-07 10:57:19-08 by jrpathak in response to 9249

Re: How to read cell comments from an xls?

Thanks John!

Direct Responses: Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.