Excel in Place file to Download in background using ABAP2XLSX

[former_member281310]

Dear Team,

Can you please suggest or provide any demo code to download excel file(attached screenshots) into application server.

Would like to have downloaded excel file in the exact above format.

Thanks,

Saleem.

[matt]

Have you considered writing a program to do it.

[former_member281310]

Hi Matthew,

I'm writing a custom program to download an excel in the mentioned format. Please provide any demo code or suggest any ideas to achieve this.

Many Thanks.

[matt]

But there's plenty of examples and demo code for using ABAP2XLSX, and writing a file to the application server is covered in the first ABAP training course.

I don't see what you're finding difficult. Can you not use the search function? Or is this just a specification and you don't know how to program? Are you wanting a free development resource? I'm sorry, but I'm genuinely puzzled concerning what you want.

[former_member281310]

Hello Matthew,

I know how to code and did many developments to download excel file into presentation server and also into the application server. The way we download the file into excel using GUI_DOWNLOAD or CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD is different(Excel output) with what I have shown in the screenshots.

In the attached screenshot if you can see there are many tabs like Format, Header, Pivot, sub1 etc. and each tab having a different set of rows and its values. I would like to download an excel file like that.

I hope now my requirement is clear to you.

Many Thanks.

[matt]

All you have to do is create the binary XLSX file using ABAP2XLSX then write it onto the application server. Is the issue that you don't know how to use ABAP2XLSX? Well, as I said, there's many many examples. Why are you asking here for another one?

[ArthurParisius]

If your ok with programming something yourself try here

[former_member281310]

Hi Arthur,

I have implemented the same code for my requirement, but it doesn't get the same format as attached below and my client wants to have only this formatted excel file.

[ArthurParisius]

Try retrieving the fieldcatalog before calling the code.

[former_member281310]

I will try and get back to you on this.

Thanks.