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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.