it will not work . you need workaround like above i mentioned.
do following :
1 . create starightable
2.export to excel
3. create one new template
4. in that add the strightable columns
5.create a pivot table based on that data.
remove the base sheet data except columns
use this template as custom in Nprinting
Just now I have created a new sheet into the Qlik sense and added a table then when I was trying to export it I'm getting only option to export into the pdf, not in excel.
One more thing, shall I directly create a pivot table instead of creating a table first then after exporting that, and after that can I export that pivot table?