Get comments from excel cells

Get comments from excel cells

hartmut_holzmann
Participant Participant
297 Views
1 Reply
Message 1 of 2

Get comments from excel cells

hartmut_holzmann
Participant
Participant

Hello together,

 

the small script show me that the comment property is nothing.

 

(defun c:GetExcelComment ( )

 

(setq ExApp (vlax-get-or-create-object "Excel.Application")
WrkBooks (vlax-get-property ExApp 'Workbooks)
Wrkbook (vlax-invoke-method WrkBooks 'Open FilePath)
ActSheet (vlax-get-property ExApp 'ActiveSheet)
)
(setq CellA1 (vlax-get-property ActSheet "Range" "A1"))
(vlax-dump-object CellA1 T)

(princ)
)

 

hartmutholzmann_0-1646148848503.png

But the specified cell has a comment in my excel file.

General, how can I read the the comments or notes from cells like the values?

 

Best regards and thank you for your help!

 

 

0 Likes
298 Views
1 Reply
Reply (1)
Message 2 of 2

hosneyalaa
Advisor
Advisor
0 Likes