SAPUI5 export to excel to one workbook and multiple sheet

[former_member586582]

We have a multiple table data which is required to export to excel in SAPUI5 (csv file or xlsx) to a single workbook with multiple sheets, each table/service data to be on each sheet , but on same excel sheet.

Please suggest.

[maheshpalavalli · Accepted solution]

I dont think SAP UI5 by default supports multiple sheets in single xls file.

Check 3rd party libraries like below which can acheive the task.

https://github.com/SheetJS/js-xlsx

Best Regards,

Mahesh

[shivam_bedwal · Accepted solution]

Hello maheshkumar.palavalli battula.ss

Can you provide the details as in how to use this 3rd party library. I also need to download miltiple sheets in one excel from sapui5 table.

Thanks & Regards,

Shivam

[maheshpalavalli · Accepted solution]

Hi Shivam Bedwal

You need to include it in the project and access it like show in the git hub example.. It will be simple you can google how to include 3rd partylibs inUI5.

BR,

Mahesh

[shivam_bedwal · Accepted solution]

Hello maheshkumar.palavalli ,

Thank you for your response. Can you tell me which method to call in the 3rd party library, and what parameters to pass, to download excel with multiple sheets.

I have included the library in my project, but trying to find out which is right method to be called. Can you help me with that.

Thanks,

Shivam

[maheshpalavalli · Accepted solution]

Hi shivam.bedwal ,

Check the below blog.

https://blogs.sap.com/2017/04/30/how-to-include-third-party-libraries-modules-in-sapui5/

BR,
Mahesh

[gregorw]

I would suggest abap2xlsx as the solution.

[FiratAsan]

Gregor,

you are writing same solutions to all questions about excel file upload and consume that (I would suggest abap2xlsx as the solution.). You are not understand questions and giving same answers to all excel file process questions. Its not good and ethic.

[gregorw]

Hi Firat,

in many cases abap2xlsx is the best option as it runs in an ABAP backend and can be used for creation but also reading XLSX files. As Sai has not given any additional information where the Excel File should be created I think abap2xlsx is still a valid option.

Best Regards
Gregor

[jorge_cabanas]

Please, follow this link, this topic is already discussed:
https://archive.sap.com/discussions/thread/3704049