Page tree
Skip to end of metadata
Go to start of metadata

Intro

The DataBindProperties object provides the means to change how data is imported using ExcelTemplate.

The DataBindingProperties object controls how the data is bound when the BindData method is called.  The DataBindingProperties can control the maximum number of rows that are imported, whether the data is transposed and which worksheet the data is imported to. 

In this sample, we use two DataBindingProperties objects-topEmployeeProperties and allEmployeeProperties-to create two different worksheets: one containing only the 10 employees with the most sales and one containing all the sales employees.  By setting the MaxRows property to 10 with the topEmployeeProperties object, we are able to display only the top 10 sales people in the AdventureWorks database. 

Code

 

Downloads

  • No labels