Microsoft Office How do I read the cell comments from an Excel spreadsheet using Powershell

How do I read the cell comments from an Excel spreadsheet using Powershell

I have a spreadsheet that I need to load into a database. Some of the information needed is saved in the cell comments. In my test spreadsheet there is a comment on the first column A1.

So far I have tried:
write-host $ExcelWorkSheet.Range("A1"

).Comment.Text
and
write-host $ExcelWorkSheet.Range("R1,C1").Offset(1,0).NoteText

I receive back either nothing or (Variant, Variant, Variant)

Is there any way to get to the cell comments through Powershell

vandreytrindade over 3 years ago

I would like to know the same thing...

PS: Recently it started to appear a lot of BOTs messages in here
Cancel
Up 0 Down

Reply

Cancel