topic Add header dynamically in QlikView https://community.qlik.com/t5/QlikView/Add-header-dynamically/m-p/980567#M967886 <HTML><HEAD></HEAD><BODY><P>I export to excel using the following code </P><P></P><P><CODE style="font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif;"><SPAN class="kwd" style="color: #00008b;">sub</SPAN><SPAN class="pln" style="color: #000000;"> xport2xl</SPAN><SPAN class="pun" style="color: #000000;">()</SPAN><SPAN class="pln" style="color: #000000;"><BR />iRow </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> xlApp </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> CreateObject</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="str" style="color: #800000;">"Excel.Application"</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlApp</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Visible </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="lit" style="color: #800000;">True</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> xlWB </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> xlApp</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Workbooks</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Add<BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> xlSheet </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> xlWB</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Worksheets</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> obj </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> ActiveDocument</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">getsheetobject</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">ChartName</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Activate<BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Cells</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Clear<BR /></SPAN><SPAN class="kwd" style="color: #00008b;">while</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #00008b;">not</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">isempty</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Cells</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">iRow</SPAN><SPAN class="pun" style="color: #000000;">,</SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pun" style="color: #000000;">)))</SPAN><SPAN class="pln" style="color: #000000;"><BR />iRow </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> iRow</SPAN><SPAN class="pun" style="color: #000000;">+</SPAN><SPAN class="lit" style="color: #800000;">2</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">wend</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> txt1 </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> ActiveDocument</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">GetSheetObject</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="str" style="color: #800000;">"CH10001"</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR />txt1</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">CopytableToClipboard </SPAN><SPAN class="lit" style="color: #800000;">TRUE</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Cells</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">iRow</SPAN><SPAN class="pun" style="color: #000000;">,</SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pun" style="color: #000000;">).</SPAN><SPAN class="kwd" style="color: #00008b;">Select</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Paste<BR /></SPAN><SPAN class="kwd" style="color: #00008b;">end</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #00008b;">sub</SPAN></CODE></P><P><SPAN class="kwd" style="color: #00008b;"><BR /></SPAN></P><P><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/99367_2.png" style="height: 30px; width: 620px;" /></P><P></P><P>How can I add dynamically a header to the report ?</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99358_1.png" style="height: 263px; width: 620px;" /></P></BODY></HTML> Fri, 18 Sep 2015 14:45:02 GMT Anonymous 2015-09-18T14:45:02Z Add header dynamically https://community.qlik.com/t5/QlikView/Add-header-dynamically/m-p/980567#M967886 <HTML><HEAD></HEAD><BODY><P>I export to excel using the following code </P><P></P><P><CODE style="font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif;"><SPAN class="kwd" style="color: #00008b;">sub</SPAN><SPAN class="pln" style="color: #000000;"> xport2xl</SPAN><SPAN class="pun" style="color: #000000;">()</SPAN><SPAN class="pln" style="color: #000000;"><BR />iRow </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> xlApp </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> CreateObject</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="str" style="color: #800000;">"Excel.Application"</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlApp</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Visible </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="lit" style="color: #800000;">True</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> xlWB </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> xlApp</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Workbooks</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Add<BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> xlSheet </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> xlWB</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Worksheets</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> obj </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> ActiveDocument</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">getsheetobject</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">ChartName</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Activate<BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Cells</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Clear<BR /></SPAN><SPAN class="kwd" style="color: #00008b;">while</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #00008b;">not</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">isempty</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Cells</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">iRow</SPAN><SPAN class="pun" style="color: #000000;">,</SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pun" style="color: #000000;">)))</SPAN><SPAN class="pln" style="color: #000000;"><BR />iRow </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> iRow</SPAN><SPAN class="pun" style="color: #000000;">+</SPAN><SPAN class="lit" style="color: #800000;">2</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">wend</SPAN><SPAN class="pln" style="color: #000000;"><BR /></SPAN><SPAN class="kwd" style="color: #00008b;">set</SPAN><SPAN class="pln" style="color: #000000;"> txt1 </SPAN><SPAN class="pun" style="color: #000000;">=</SPAN><SPAN class="pln" style="color: #000000;"> ActiveDocument</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">GetSheetObject</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="str" style="color: #800000;">"CH10001"</SPAN><SPAN class="pun" style="color: #000000;">)</SPAN><SPAN class="pln" style="color: #000000;"><BR />txt1</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">CopytableToClipboard </SPAN><SPAN class="lit" style="color: #800000;">TRUE</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Cells</SPAN><SPAN class="pun" style="color: #000000;">(</SPAN><SPAN class="pln" style="color: #000000;">iRow</SPAN><SPAN class="pun" style="color: #000000;">,</SPAN><SPAN class="lit" style="color: #800000;">1</SPAN><SPAN class="pun" style="color: #000000;">).</SPAN><SPAN class="kwd" style="color: #00008b;">Select</SPAN><SPAN class="pln" style="color: #000000;"><BR />xlSheet</SPAN><SPAN class="pun" style="color: #000000;">.</SPAN><SPAN class="pln" style="color: #000000;">Paste<BR /></SPAN><SPAN class="kwd" style="color: #00008b;">end</SPAN><SPAN class="pln" style="color: #000000;"> </SPAN><SPAN class="kwd" style="color: #00008b;">sub</SPAN></CODE></P><P><SPAN class="kwd" style="color: #00008b;"><BR /></SPAN></P><P><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/99367_2.png" style="height: 30px; width: 620px;" /></P><P></P><P>How can I add dynamically a header to the report ?</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99358_1.png" style="height: 263px; width: 620px;" /></P></BODY></HTML> Fri, 18 Sep 2015 14:45:02 GMT https://community.qlik.com/t5/QlikView/Add-header-dynamically/m-p/980567#M967886 Anonymous 2015-09-18T14:45:02Z