Yes. To write comments, you could use write_comment() from Spreadsheet::WriteExcel or Spreadsheet::WriteExcelXML as appropriate for the file type (assuming the usual xls or xlsx).
Read the docs for details. With these, you should be able to find modules/functions to read comments as well. Of course, other modules may be better suited for your task but these should get you started.
| [reply] [d/l] |
Thanks a lot - I overlooked that part.
| [reply] |
Hi - I wonder if there is a way to read/write comments from/to Excel or OpenOffice without using Win32::OLE? Theoretically :) yes :) Pratically :) Maybe :) Depends on what spreadsheet excel modules support
| [reply] |
Well - I have bunch (50+) of large XLS files (Excel 2003) that are used as data for our software project - and developers are allowed to maintain them by hand and insert commands.
I wrote some Perl tools to do various automated data verification and population. But for that I need to be able to preserve comments in data files
Since part of the team moved to OpenOffice (but using XLS format) ideally I am looking for solution that would not use OLE - just for simplicity. I know how to do it (read/write comments) in OLE - at least for Excel APIs.
| [reply] |
Um , ok, and then what happened?
| [reply] |