How to import TOP N rows in a data set with ExcelTemplate


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.


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); of ExcelTemplate code...

Related posts:

Leave a Reply

Your email address will not be published. Required fields are marked *