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

Exoprt Data Grind to excel

Answers (4)