topic How to read cell comments from Excel ? in QlikView https://community.qlik.com/t5/QlikView/How-to-read-cell-comments-from-Excel/m-p/815350#M287564 <HTML><HEAD></HEAD><BODY><P>Good day</P><P></P><P>I wonder if it is possible to read the comments in an Excel spreadsheet to QlikView.</P><P></P><P>Comments are made by the menu: Insert Comment</P><P></P><P>Thanks to all</P></BODY></HTML> Thu, 11 Dec 2014 13:15:12 GMT rafaelattux 2014-12-11T13:15:12Z How to read cell comments from Excel ? https://community.qlik.com/t5/QlikView/How-to-read-cell-comments-from-Excel/m-p/815350#M287564 <HTML><HEAD></HEAD><BODY><P>Good day</P><P></P><P>I wonder if it is possible to read the comments in an Excel spreadsheet to QlikView.</P><P></P><P>Comments are made by the menu: Insert Comment</P><P></P><P>Thanks to all</P></BODY></HTML> Thu, 11 Dec 2014 13:15:12 GMT https://community.qlik.com/t5/QlikView/How-to-read-cell-comments-from-Excel/m-p/815350#M287564 rafaelattux 2014-12-11T13:15:12Z Re: How to read cell comments from Excel ? https://community.qlik.com/t5/QlikView/How-to-read-cell-comments-from-Excel/m-p/815351#M287565 <HTML><HEAD></HEAD><BODY><P>I would say that it is not possible.</P><P></P><P>This thread seems to share my view:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/11760#11760" title="http://community.qlik.com/message/11760#11760">http://community.qlik.com/message/11760#11760</A></P><P></P><P>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.</P><P></P><P>Alternative you can probably use a VBA-macro in Excel to write all comments into a separate comment sheet. Here are some ideas:</P><P></P><P><A href="http://www.extendoffice.com/documents/excel/765-excel-convert-comments-to-cells.html" title="http://www.extendoffice.com/documents/excel/765-excel-convert-comments-to-cells.html">http://www.extendoffice.com/documents/excel/765-excel-convert-comments-to-cells.html</A></P><P></P><P>Kind regards</P><P></P><P>Niklas</P></BODY></HTML> Thu, 11 Dec 2014 13:27:17 GMT https://community.qlik.com/t5/QlikView/How-to-read-cell-comments-from-Excel/m-p/815351#M287565 Anonymous 2014-12-11T13:27:17Z