ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Create new sheet when Row Limit exceeds during Excel Export in Windows Application using C#<p>Explain in more details what exactly mean if excel sheets&rsquo; limit exceeds.</p> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/706112/Create-new-sheet-when-Row-Limit-exceeds-during-Excel-Export-in-Windows-Application-using-C/https://www.aspforums.net:443/Threads/706112/Create-new-sheet-when-Row-Limit-exceeds-during-Excel-Export-in-Windows-Application-using-C/Tue, 20 Mar 2018 02:34:08 GMTCreate new sheet when Row Limit exceeds during Excel Export in Windows Application using C#<p>i want to export large volume of data from datagridview to excel sheet if the limit of excel file is about 2l then the remaining data of datagridview should be exported automatically to next excel file ... and here is the current code its working file i need that extension feature alone can you please guide me to do this&nbsp;</p> <pre class="brush: csharp">Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); // creating new Excelsheet in workbook Microsoft.Office.Interop.Excel._Worksheet worksheet = null; // see the excel sheet behind the program app.Visible = true; // get the reference of first sheet. By default its name is Sheet1. // store its reference to worksheet worksheet = workbook.Sheets[&#34;Sheet1&#34;]; worksheet = workbook.ActiveSheet; // changing the name of active sheet worksheet.Name = &#34;Exported from gridview&#34;; // storing header part in Excel for (int i = 1; i &lt; dataGridView1.Columns.Count + 1; i++) { worksheet.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText; } // storing Each row and column value to excel sheet for (int i = 0; i &lt; dataGridView1.Rows.Count - 1; i++) { for (int j = 0; j &lt; dataGridView1.Columns.Count; j++) { worksheet.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); } } // save the application workbook.SaveAs(&#34;D:\\DatagridviewDowloadEmails.xls&#34;, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing); // Exit from the application MessageBox.Show(&#34;Your Exported file is in D:&#34;); app.Quit(); </pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/706112/Create-new-sheet-when-Row-Limit-exceeds-during-Excel-Export-in-Windows-Application-using-C/https://www.aspforums.net:443/Threads/706112/Create-new-sheet-when-Row-Limit-exceeds-during-Excel-Export-in-Windows-Application-using-C/Tue, 20 Mar 2018 03:21:17 GMTCreate new sheet when Row Limit exceeds during Excel Export in Windows Application using C#<p>1. Add RowNumber to your Table rows and get data page wise.</p> <p>2. i.e. Get first 1 lac records, export to one Excel, then second 1 lac and so on.</p> <p>3. For getting data Page Wise from SQL Server refer.</p> <h1 class="header"><a title="Implement Paging DataGridView in Windows Forms (WinForms) Application using C# and VB.Net'a" href="https://www.aspsnippets.com/Articles/Implement-Paging-DataGridView-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx">Implement Paging DataGridView in Windows Forms (WinForms) Application using C# and VB.Net</a></h1>https://www.aspforums.net:443/Threads/706112/Create-new-sheet-when-Row-Limit-exceeds-during-Excel-Export-in-Windows-Application-using-C/https://www.aspforums.net:443/Threads/706112/Create-new-sheet-when-Row-Limit-exceeds-during-Excel-Export-in-Windows-Application-using-C/Tue, 20 Mar 2018 04:44:06 GMT