ods tagsets.excelxp-Export multiple tables to multiple sheets

[Ronein]

Hello

The foillowing code create 2 sheets.

In sheet1 there are 2 tables.

In sheet2 there are 2 tables.

My question is why the titles are not printed out in the excel XLS file?

Title;
ods tagsets.excelxp file="path/test.xls"  style=minimal
        options(sheet_interval="none" sheet_name='Ron1');
proc print data=sashelp.class(obs=5)noobs;
Title 'Sheet1-table1';
run;
proc print data=sashelp.air(obs=5) noobs;
Title 'Sheet1-table2';
run;
ods tagsets.excelxp options(sheet_interval="table");
ods tagsets.excelxp options(sheet_interval="none" sheet_name='Ron2');
proc print data=sashelp.orsales(obs=5)noobs;
Title 'Sheet2-table1';
run;
proc print data=sashelp.prdsale(obs=5)noobs;
Title 'Sheet2-table2';
run;
ods tagsets.excelxp close;

[andreas_lds]

The titles should be in the xls/xml file, have a look at the print preview! If you want them embedded in the worksheets, you have to use the option embedded_titles='yes'.

[Kurt_Bremser]

---

@andreas_lds wrote:

The titles should be in the xls/xml file, have a look at the print preview! If you want them embedded in the worksheets, you have to use the option embedded_titles='yes'.

---

You beat me to it while I was still following Maxim 6 😉

[Kurt_Bremser · Accepted solution]

Titles in tagsets.ecelxp will only be visible in the printed output (look at the print preview).

If you want to see them in the worksheets, use the embedded_titles='yes' option.