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

Last Reply 10 months ago By Mudassar

Posted 10 months 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 10 months ago.
Posted 10 months 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