I have this datatable that I need to loop for my excel exporting function.
And I have to export data that exceeds the row limit of excel worksheet.

now I want to know how to create a query of limit on the datatable.select in such way like in sql.

Example: (In mySql) Select * from table limit 0,10;

Is there such query on the datatable.select that I can use?

Like datatable.select("LIMIT 0,10")


Since there is a row limit, I would find the place where you are building the dataset (I am assuming you are iterating through records to build them) and have a condition statement that is the limit. When you reach the limit, I would send that to Excel, and build a new dataset.