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

shalinip

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

Mudassar

0 3

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.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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