Skip to Content

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

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

excelsheets.png (12.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 27, 2018 at 01:47 PM

    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."

    Add comment
    10|10000 characters needed characters exceeded