topic Re: NPrinting in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172732#M11967 <HTML><HEAD></HEAD><BODY><P>Pavan - if you are suing a straight table in Excel, you can apply Excel-based formatting as follows: <A href="http://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/CanIApplyExcelFormattingExcelReports/Excel-formatting.htm" title="http://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/CanIApplyExcelFormattingExcelReports/Excel-formatting.htm">http://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/CanIApplyExcelFormattingExcelReports/Excel-formatting.htm</A></P><P></P><P>If you are using a pivot table, you will have to use one of the available pivot table styles (<A href="https://support.office.com/en-us/article/Change-the-style-of-your-PivotTable-dc5c31fc-3e85-410a-880d-9f164c3dd92c" title="https://support.office.com/en-us/article/Change-the-style-of-your-PivotTable-dc5c31fc-3e85-410a-880d-9f164c3dd92c">Change the style of your PivotTable - Excel</A>) or create your own.</P></BODY></HTML> Thu, 25 Aug 2016 15:48:29 GMT Stephen_Jasionowski 2016-08-25T15:48:29Z NPrinting https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172731#M11966 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to get formatted excel output from Nprinting.&nbsp; The qvw file has objects like pivot table which doesn't have any color trends. But when sent to Npriniting, the output should display formatted excel like applying shading&nbsp; or color only to the totals cells/ bold the headers/ apply border to the pivot object.</P><P></P><P>Thank you,</P><P>Pavan</P></BODY></HTML> Thu, 25 Aug 2016 14:43:25 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172731#M11966 Anonymous 2016-08-25T14:43:25Z Re: NPrinting https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172732#M11967 <HTML><HEAD></HEAD><BODY><P>Pavan - if you are suing a straight table in Excel, you can apply Excel-based formatting as follows: <A href="http://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/CanIApplyExcelFormattingExcelReports/Excel-formatting.htm" title="http://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/CanIApplyExcelFormattingExcelReports/Excel-formatting.htm">http://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/CanIApplyExcelFormattingExcelReports/Excel-formatting.htm</A></P><P></P><P>If you are using a pivot table, you will have to use one of the available pivot table styles (<A href="https://support.office.com/en-us/article/Change-the-style-of-your-PivotTable-dc5c31fc-3e85-410a-880d-9f164c3dd92c" title="https://support.office.com/en-us/article/Change-the-style-of-your-PivotTable-dc5c31fc-3e85-410a-880d-9f164c3dd92c">Change the style of your PivotTable - Excel</A>) or create your own.</P></BODY></HTML> Thu, 25 Aug 2016 15:48:29 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172732#M11967 Stephen_Jasionowski 2016-08-25T15:48:29Z Re: NPrinting https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172733#M11968 <HTML><HEAD></HEAD><BODY><P>My bad; pressed the wrong button and accidently rejected Pavan V's post in which he wrote "Thank you Stephen".</P><P>Sorry for that.</P></BODY></HTML> Thu, 25 Aug 2016 16:05:52 GMT https://community.qlik.com/t5/Qlik-NPrinting/NPrinting/m-p/1172733#M11968 oknotsen 2016-08-25T16:05:52Z