Hi, I am trying to export the outputs of multiple queries in a single Excel worksheet and I want to insert blank rows and comment rows between the outputs.
I am using the following query-:
@export set filename="C:\data\Test_output1.xls" appendfile="clear";
select * from table1 limit 5;
select * from table2 limit 5;
But the outputs of the two queries are getting exported in separate worksheets of the workbook and the comment line is not getting printed anywhere.
Please help me with this.