cancel
Showing results for 
Search instead for 
Did you mean: 

How to download edited Excel files via Fiori

yumiyazaki
Explorer
0 Kudos

Hi all,

I want to download edited Excel files.(e.g. merged, colored, justified...etc)

At first I thought using OLE, but in WEBGUI I can not download by using OLE.

After that, I found that OLE can be used in SAPGUI or Webdynpro only.

Now,My client want to use SAP fiori and download edit excel files.

Could anyone know that how to download edited Excel files via fiori?

Please teach me.

Regards.

Yuji

Accepted Solutions (1)

Accepted Solutions (1)

maheshpalavalli
Active Contributor

There are many ways to download the excel

1. Using SAP UI5 Library:

https://ui5.sap.com/#/entity/sap.ui.export.Spreadsheet

2. Using Opensource

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

3. Using the backend SAP also, you can generate the excel sheet and download it using the steam methods:

https://wiki.scn.sap.com/wiki/display/ABAP/abap2xlsx

BR,

Mahesh

yumiyazaki
Explorer
0 Kudos

Hi Mahesh,

Thanks for answering.

I will use your explanation as reference.

By the way,can explanation1~3 all use merged (or centerd,justified,colored) cells?

I could not find any answer for this. I'm so sorry for lacking any knowledges for JAVAScript.

Regards.

Yuji

gregorw
Active Contributor

With abap2xlsx you can merge, center and color cells. And it's ABAP based.

maheshpalavalli
Active Contributor

It's possible with the Sheet.js not sure if it is possible with sap.ui.export.spreadsheet.

And from gregorw comment, it looks like it works for the abap2xls and if you are comfortable go with the abap2xlsx and use the odata stream methods to download the excel sheet.

BR,

Mahesh

Answers (1)

Answers (1)

yumiyazaki
Explorer
0 Kudos

Thanks for help.

These answers make me clearly.

I will try to develop.

Regards.

Yuji