Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel - How to load cell comments

Is there any way to load cell comments from Excel into QlikView?

3 Replies
Not applicable
Author

can u please elaborate.

suniljain
Master
Master

I think its not possible. Cell Comment is for documentation purpose and qlikview deals with excel data only.

Not applicable
Author

In Excel, when you right-click a cell, you can select "Insert comment" to store text information about that cell. I want to get that information along with cell content.

I think it can be done writing a VB script in the worksheet that takes the comments and saves them into a separate hidden row, and load that into QlikView. But it's not an option.