In the previous part, we discussed how to create and modify the XSL Transformation using T code XSLT_TOOL.

Part 1: http://scn.sap.com/people/manikandan.jeyaram/blog/2013/09/11/download-ms-excel-with-formatting-options-using-xslt

Now we are going to call this XSLT in our program.

Create a program in SE38 (ZEXCEL_DOWNLOAD). The algorithm of this program is explained below:

  • Populate the internal table.
  • Pass the internal table contents to the transformation which is created in XSLT_TOOL (Z_EXCEL_DOWNLOAD).
  • The output of the transformation will be an XML string. Put this string in an XML table.
  • CALL METHOD cl_gui_frontend_services=>file_save_dialog to open the dialog box to identify the location for saving the file.
  • Pass the XML table to GUI_DOWNLOAD. The excel sheet gets downloaded in the desired path.

16. Program.jpg

Step 7:

Execute the program.

17. Save Excel.jpg

Save the Excel sheet. Here is the output of this program:

18. Output.jpg

Please note that the conditional formatting is applied only to cell G2. If we want to extend the range for this conditional formatting, we need to make one more adjustment in the XSLT.

19. Conditional formatting code.jpg

As you can see, in the self-generated code, the conditional formatting was applied only to Row 2, Column 7. I have changed the range manually here up to 100 rows. Now the conditional formatting is applied to 100 rows. You can see the excel output below:

20. Conditional formatting excel.jpg

Pros:

  • Faster download
  • Download at one shot
  • Minimal coding effort. We use auto-generatedcode and do minimal changes to it.
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply