Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way to load cell comments from Excel into QlikView?
can u please elaborate.
I think its not possible. Cell Comment is for documentation purpose and qlikview deals with excel data only.
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.