Export of Spreadsheet into excel in SAP BO Design Studio

[jyoti_senapati]

Hello,

I have an requirement of exporting a spreadsheet into Microsoft excel in SAP BO Design Studio 1.6 . I can export the cross tab into the excel but the lies with the spreadsheet.

Please provide any valuable input.

[former_member296163 · Accepted solution]

Hi Jyoti,

There is no default option to export to excel - I've created a cross tab made it visible false assigned with same data source as spread sheet.The export to excel icon with below code produces the result.

if (PAGEBOOK_1.getSelectedPageIndex() == 1) {

APPLICATION.export(ExportType.EXCEL_xlsx,[CROSSTAB_1]) ; }

elseif

(PAGEBOOK_1.getSelectedPageIndex() == 2)

{

APPLICATION.export(ExportType.EXCEL_xlsx,[CROSSTAB_2]);}

elseif

(PAGEBOOK_1.getSelectedPageIndex() == 3)

{

APPLICATION.export(ExportType.EXCEL_xlsx,[CROSSTAB_REPORT]);}

[jyoti_senapati · Accepted solution]

Thanks.. 🙂

[TammyPowlas]

I don't see how to do that in the product; please support this idea on Idea Place:

https://ideas.sap.com/D27339

[jyoti_senapati]

Thanks....