Intro

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

• Template:  BindingPropertiesTemplate.xlsx
• Output:  BindingProperties_output.xlsx