Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day
I wonder if it is possible to read the comments in an Excel spreadsheet to QlikView.
Comments are made by the menu: Insert Comment
Thanks to all
I would say that it is not possible.
This thread seems to share my view:
http://community.qlik.com/message/11760#11760
QlikView has a rather narrow approach to Excel in terms of just being able to import straight tables in selectable tabs, so your only solution is to ask end users to move comment into cells instead.
Alternative you can probably use a VBA-macro in Excel to write all comments into a separate comment sheet. Here are some ideas:
http://www.extendoffice.com/documents/excel/765-excel-convert-comments-to-cells.html
Kind regards
Niklas
I would say that it is not possible.
This thread seems to share my view:
http://community.qlik.com/message/11760#11760
QlikView has a rather narrow approach to Excel in terms of just being able to import straight tables in selectable tabs, so your only solution is to ask end users to move comment into cells instead.
Alternative you can probably use a VBA-macro in Excel to write all comments into a separate comment sheet. Here are some ideas:
http://www.extendoffice.com/documents/excel/765-excel-convert-comments-to-cells.html
Kind regards
Niklas