Start a new topic

Data export

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 on;

@export set filename="C:\data\Test_output1.xls" appendfile="clear";

select * from table1 limit 5;

@echo "mytext";

select * from table2 limit 5;

@export off;

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.

Login or Signup to post a comment