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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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.