Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

This is the installation instruction for the Export to Spreadsheet (Excel, .xlsx) with abap2xlsx functionality. If you want to read the background story why this was created check out this blog post: WebClient UI Export to Spreadsheet with abap2xlsx.

Prerequisites

Before you can install the class ZCL_CHTMLB_TAB_EXCEL_EXPORT using SAPLink, you have to install the latest daily build of abap2xlsx. Here you find the abap2xlsx Installation Guide. Please also read the comments in the guide.

Setup Export to Spreadsheet with abap2xlsx

Now you can get the repository https://github.com/sapmentors/SAPCRMa2xExport and install it using abapGit. After the activation of the class you have to create this service using transaction SICF:

After you've created the new service switch to the External Aliases in SICF and create this alias (/sap/webcuif/uif_export_tab) and point it to the target handler created above:


Now start the CRM Web UI, execute a search and click on the Export to Spreadsheet button.

2 Comments

  1. Former Member

    Hello Gregor,

    Nice work . Is it possible to format the cell content using this approach?

    I have a requirement with Excel to export of table view , to display a cell value with notes like below.

    -test1
    -test2

    -test3

    But in the CSV file it is presented as below : -test1 - test2 -test3

    Please suggest if formating of string is possible in this case .

     

    1. Please check out ZDEMO_EXCEL14. You're welcome to send me a patch for the class you can download here.