Exoprt Data Grind to excel

Question

Exoprt Data Grind to excel in .NET 3.5 C#?

Ahmed JS · Answer

Hi below link you can get http://sqlneed.blogspot.com/2014/03/how-to-export-datagridview-to-excel.html

Jacke Elis · Answer

Hi you can also try with this C# dll for excel files  something like the following: var file = new ExcelFile (); var sheet = file.Worksheets.Add( DataGridView ); DataGridViewConverter .ExportToDataGridView( sheet dataGridView1 new ExportToDataGridViewOptions ()); file.Save( DataGridView.xlsx ); Also here is an article about how you can import or export a DataGridView control to excel .

Joginder Banger · Answer

Look a simple code private void ExportDataSetToExcel(DataTable table string fileName) { //Creae an Excel application instance excel.Application excelApp = new excel.Application(); //Create an Excel workbook instance and open it from the predefined location excel.Workbook excelWorkBook = excelApp.Workbooks.Open(fileName); excelApp.DisplayAlerts = false; foreach (excel._Worksheet sheet in excelWorkBook.Sheets) { if (sheet.Name.ToLower() != testing) { sheet.Delete(); excelWorkBook.Save(); } } excelApp.DisplayAlerts = true; excel.Worksheet excelWorkSheet = (excel.Worksheet)(excelWorkBook.Sheets.Add()); for (int i = 1; i { excelWorkSheet.Cells[1 i] = table.Columns[i - 1].ColumnName; } for (int j = 0; j { for (int k = 0; k { excelWorkSheet.Cells[j + 2 k + 1] = table.Rows[j].ItemArray[k].ToString(); } } excelWorkBook.Save(); excelWorkBook.Close(); excelApp.Quit(); Response.Clear(); Response.AddHeader(Content-Disposition attachment; filename= + Product + .xls); Response.AddHeader(Content-Length fileName); Response.ContentType = application/octet-stream; Response.WriteFile(fileName); Response.End(); } //Button Export TO Excel protected void ExportToExcel(object sender EventArgs e) { productexport = objproduct.importProductData(); productexport.Columns.Add(col); col.SetOrdinal(0); for (int i = 0; i { productexport.Rows[i][SrNo] = i + 1; } string temp = Server.MapPath(Export/Product_Export.xls); var fpath = temp; if (fpath.Trim() != string.Empty) ExportDataSetToExcel(productexport fpath); }

Abhay Shanker · Answer

check below link http://csharp.net-informations.com/excel/csharp-excel-datagridview.htm