I would need to pass an internal table and a variable from my program to this Transformation and then show these details in my Excel sheet. I can create my own import parameters for an XSLT. This is kind of import parameter for the XSL Transformation. To bring our own data in to the excel sheet we need to make some modifications to this generated XML code.
Īt this level, on executing this transformation, we will be able to download the excel sheet which we have prepared earlier with the sample data. Paste the code which is copied from the Notepad in the place where the arrow mark points (refer below screenshot). In this tab we will be able to see some empty tags. Enter a Transformation name and click on create. Refer the below screenshot to see how the generated code looks like. Copy this code since we will be using this in the XSL transformation which is explained in the next step. The styles and properties of the cells will be represented in this generated XML code. We will be able to see the XML code which gets generated.
Right click on the saved file and open the same in Notepad. While saving, save it as XML spreadsheet. Likewise do all the necessary formatting.Īfter the formatting is done, SAVE the file. The condition is such that if the value in the cell is greater than 100, it is made Red Bold. Conditional formatting is given for the cell G2.Borders are given for the desired cells.In this Excel sheet, the following formatting has been done. Refer the screenshot below for a sample excel sheet with necessary formatting. Fill in some sample data (just one record will do) to know how our output is going to be. Open an Excel sheet and do the necessary formatting. Step by step details of this approach is explained below: This way, we are able to download the data faster than OLE approach. In this approach, we are using XSL Transformation technique to download data. Our objective is to find a solution which provides better means of downloading the data. But download using OLE technique is very slow for enormous amount of data. OLE technique can be used for this requirement. Download the contents of the internal table in an excel sheet with formatting options.