How to remove selection area in export to excel - SAP DESIGN STUDIO

[sinaei]

Dear All,

We need to export to excel our tables in design tudio, and I am using the standard feature.

APPLICATION.export(ExportType.EXCEL_xlsx,[CROSSTAB_35])

It works fine but when we export it, the excel file contins two worksheets, one for table and another for selection area.

Does anyone know how cn we remove the second sheet?

Users do not want to see this worksheet.

Thank
Sepide

[TammyPowlas · Accepted solution]

I don't think this is possible; this is standard functionality

Read this SAP Note https://launchpad.support.sap.com/#/notes/2435932

"When doing an export to Excel, 2 worksheets are created per exported crosstab, one for the results and one for the selections."

[sinaei · Accepted solution]

Thank Tommy for your answer