Export .xlsx file from Webclient UI using abap2xlsx framework

[Former Member]

Hello,

I have an urgent requirement to export the contents of internal tables to a .xlsx file using abap2xlsx framework.

Classes like CL_GUI_FRONTEND_SERVICES or FM's like GUI_DOWNLOAD doesn't work for Webclient UI.

Could anyone suggest me the proper stepwise solution with code snippet.

Regards,

Suyog

[Former Member]

Hi Suyog,

Do you want to download the table view contents to a xls file right?? Is my understanding is correct?

IF it is then go to the .html page of your table view and there fill the attribute downloadToexcel.

Data: lv_excel type string.

Further clarification check the view BT115QIT_SLSQ/Items.

Regards,

Rajya lakshmi Ch.

[Former Member]

Hi Rajya Lakshmi,

Thanks for your reply.

There are 4 different table views which are in parallel. Standard 'export to spreadsheet' functionality is already there for each view. But I need a custom functionality because I want only 1 excel sheet for these 4 views. Below is a sample excel sheet format.

Regards,

Suyog

[Former Member]

Hi Suyog,

May be You can keep a button on over view page and Create an action for that and in that action method keep your code to download to EXCEL. where GUI_DOWNLOAD will work.

Regards,

Rajya lakshmi