• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

Spreadsheet::ParseExcel - cell comments

Hi there,

How to get cell comments from xls using Spreadsheet::ParseExcel ...

I can get out almost everything from xls, but I can't read a cell comments. Any idea ??? Please ...
0
zozzi
Asked:
zozzi
  • 2
1 Solution
 
jmcgOwnerCommented:
You're right. Spreadsheet::ParseExcel has not developed so far that it can handle formulas or comments. Spreadsheet::WriteExcel can write comments, however, so if you are willing to get your hands a bit dirty, you might be able to figure out how, between the two chunks of code, you could add handling of the NOTE type to ParseExcel.pm. (I'll admit that I still don't have a clue as to how to do it after staring somewhat blearily at the source code for the various WriteExcel and ParseExcel modules for almost an hour.)
0
 
jmcgOwnerCommented:
Nothing has happened on this question in more than 6 weeks. It's time for cleanup!

My recommendation, which I will post in the Cleanup topic area, is to
accept answer by jmcg [grade B] (not a complete solution).

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now