Pagging data using smart markers

Aspose.Cells Product Family
1

Hi aspose.cells team.

I'm working with aspose.cells smart markers and i want to bind my data from a dataset to a spreadsheets.

And the dataset I'm using has more than 1000 rows so I need to get this rows by pages to get more performance.

The question is: Is there a way to use an special kind of smart marker to do this or I 'll have to create dynamics smart markers on runtime binding the result of each page?

Regards, Tenaris

2

Hi,

Thanks for considering Aspose.

Well, normally smart markers source is a datatable or a dataset. So whatever the rows or records are there in the datatable they all will be bound to the markers in a worksheet. I think you may try to fill a datatable with your specific number of rows or records and set it as the data source to designer workbook.

Thank you.