...

We're done creating the template. Now it's time to write the code.

Writing the Code

SOMETHING ABOUT BINDROWDATA and BINDCOLUMN DATA

1. Include the SoftArtisans.OfficeWriter.ExcelWriter namespace in the code behind

using SoftArtisans.OfficeWriter.ExcelWriter;

2. In the method that is going to actually run the report, instantiate the ExcelTemplate object.

ExcelTemplate XLT = new ExcelTemplate();

3. Open the template file from earlier with the ExcelTemplate.Open() method.

XLT.Open(Page.MapPath("//templates//part1_template.xlsx"));

4. Create a DataBindingProperties object. Although we won't be changing any of the binding properties, a DataBindingProperties is a required parameter in all ExcelTemplate data binding methods.

DataBindingProperties dataProps = XLT.CreateDataBindingProperties();

5.

Run your code

Final Code

Add code here

Downloads