Create new sheet when Row Limit exceeds during Excel Export in Windows Application using C#

Last Reply one year ago By Mudassar

Posted one year ago

Hi 

export from datagridview to excel is working fine.. i want a little extension from this export..

i want to export data from datagridview to new excel automatically if existing excel sheet's limit exceeds ..

 

can anyone help to me to do this ..

 

thanks in advance

 

shalini 

You are viewing reply posted by: Mudassar one year ago.
Posted one year ago

1. Add RowNumber to your Table rows and get data page wise.

2. i.e. Get first 1 lac records, export to one Excel, then second 1 lac and so on.

3. For getting data Page Wise from SQL Server refer.

Implement Paging DataGridView in Windows Forms (WinForms) Application using C# and VB.Net