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.

Get and transform excel 2013 download