Can I have two different templates and generate one exel report one sheet per report in same excel file?
Which reports you want to split for two different layout. Can you describe more. We have macro for that if you would share in detail
for me it is possible to create two report and generate one excel file
Are you referring to sources from multiple connections?
If yes, then yes you can, as long as the connections are in the same app.
When adding elements into your excel report you should be able to switch connections in the top pannel.
Using VBScript to various obj
Try with NPrinting , using this you could achieve the desired output
NPrinting Features for Creating Excel Reports
QlikView NPrinting 16 Tutorials - Excel Reports
yes you can,
take two different excel sheet base sheet data and create it in single excel and use that template in designer.
Retrieving data ...