Problem
ExcelTemplate allows users to specify the number of rows they want to important from a data set. For instance, importing only the top 20 rows into the report.
Solution
When importing multiple rows of data with the BindData() method, you can limit the maximum number of rows to import using the MaxRows property of the DataBindingProperties class.To limit the max number of rows to 20:
//Create a DataBindingProperties object
DataBindingProperties dataprops = xlt.CreateDataBindingProperties();
//Limit the number of rows to import to 20
dataprops.MaxRows = 20;
//Bind the data using that DataBindingProperties object
xlt.BindData(dataTable, "DataSourceName", dataprops);
...rest of ExcelTemplate code...
Share the post "How to import TOP N rows in a data set with ExcelTemplate"
Follow