Datagridview to excel

Question

How to export windows form datetime picker and datagridview export to excel sheet

Rahul Prasad · Answer

Please refer to this link: How to Export Datatable to Excel through DataGridView Hope it helps

Najjaf Shuja · Answer

seems you are creating datagridview programatically, well here is another code, get datasource as datatable, DataTable dataTable = (DataTable)( dgv_Patients .DataSource); //Now call Function, writeDataInExcel(dataTable, "Test") private void WriteDataInExcel(DataTable dataTable, string name) { Microsoft.Office.Interop.Excel.Application excel; Microsoft.Office.Interop.Excel.Workbook excelworkBook; Microsoft.Office.Interop.Excel.Worksheet excelSheet; Microsoft.Office.Interop.Excel.Range excelCellrange; // Start Excel and get Application object. excel = new Microsoft.Office.Interop.Excel.Application(); // for making Excel visible excel.Visible = false; excel.DisplayAlerts = false; // Creation a new Workbook excelworkBook = excel.Workbooks.Add(Type.Missing); // Workk sheet excelSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelworkBook.ActiveSheet; excelSheet.Name = "Sheet1"; excelSheet.Cells[1, 1] = "Details"; excelSheet.Cells[1, 2] = "Date : " + DateTime.Now.ToShortDateString(); int rowcount = 2; foreach (DataRow datarow in dataTable.Rows) { rowcount += 1; for (int i = 1; i { // on the first iteration we add the column headers if (rowcount == 3) { excelSheet.Cells[2, i] = dataTable.Columns[i - 1].ColumnName; excelSheet.Cells.Font.Color = System.Drawing.Color.Black; } excelSheet.Cells[rowcount, i] = datarow[i - 1].ToString(); //for alternate rows if (rowcount > 3) { if (i == dataTable.Columns.Count) { if (rowcount % 2 == 0) { excelCellrange = excelSheet.Range[excelSheet.Cells[rowcount, 1], excelSheet.Cells[rowcount, dataTable.Columns.Count]]; //FormattingExcelCells(excelCellrange, "#CCCCFF", System.Drawing.Color.Black, false); } } } } } excelCellrange = excelSheet.Range[excelSheet.Cells[1, 1], excelSheet.Cells[rowcount, dataTable.Columns.Count]]; excelCellrange.EntireColumn.AutoFit(); excelCellrange = excelSheet.Range[excelSheet.Cells[1, 1], excelSheet.Cells[2, dataTable.Columns.Count]]; excelworkBook.SaveAs("D:\" + name + ".xlsx"); excelworkBook.Close(); excel.Quit(); }

Angel Princess · Answer

giving errors check zip file

Najjaf Shuja · Answer

add namespaces. using System.Windows.Controls; using System.Windows.Forms; using System.Windows.Input; In export button click paste this code, dgv_Patients.SelectAllCells(); dgv_Patients.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, dgv_Patients); String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); String result = (string)Clipboard.GetData(DataFormats.Text); dgv_Patients.UnselectAllCells(); System.IO.StreamWriter file = new System.IO.StreamWriter(@”C:\Users	est.xls”); file.WriteLine(result.Replace(',', ' ')); file.Close(); MessageBox.Show(" Exporting DataGrid data to Excel file created");

Angel Princess · Answer

private void bindgridPatient() { DataTable dt = new DataTable(); dt = MainClass.GetDatabyQuery("select * from tbl"); if (dt.Rows.Count > 0) { dgv_Patients.Rows.Clear(); for (int i = 0; i <= dt.Rows.Count - 1; i++) { dgv_Patients.Rows.Add(); dgv_Patients.Rows[dgv_Patients.Rows.Count - 1].Cells["SrNo"].Value = dgv_Patients.Rows.Count; dgv_Patients.Rows[dgv_Patients.Rows.Count - 1].Cells["Name"].Value = dt.Rows[i]["Name"].ToString(); } } It is my datagridview code

Najjaf Shuja · Answer

post your sample code or datagridview code so that I would be able to create full method for you.

Manoj Bhoir · Answer

Hi, You can try this code i have written for one of my application. /// /// Export Data from data grid to Excel file. /// /// Excel file name with path as String /// Data Grid to export in Excel /// Excel Sheet Name as String /// public static void ExportToExcel(string FilePath, DataGridView DataGrid, string SheetName) { try { using (StreamWriter _mFileStream = new StreamWriter(FilePath, false)) { _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); for (int x = 0; x _mFileStream.WriteLine(" ", DataGrid.Columns.Item(x).Width); } _mFileStream.WriteLine(" "); for (int i = 0; i _mFileStream.WriteLine(" "); _mFileStream.WriteLine(string.Format(" {0} ", DataGrid.Columns.Item(i).HeaderText)); _mFileStream.WriteLine(" "); } _mFileStream.WriteLine(" "); for (int intRow = 0; intRow _mFileStream.WriteLine(string.Format(" ", DataGrid.Rows(intRow).Height)); for (int intCol = 0; intCol _mFileStream.WriteLine(" "); _mFileStream.WriteLine(string.Format(" {0} ", DataGrid.Item(intCol, intRow).Value.ToString)); _mFileStream.WriteLine(" "); } _mFileStream.WriteLine(" "); } _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.WriteLine(" "); _mFileStream.Close(); _mFileStream.Dispose(); } } catch (Exception ex) { } } How to use : ExportToExcel(FilePath, DataGrid, "Sheet1")

Angel Princess · Answer

Not resolving. Any other code??

Najjaf Shuja · Answer

These errors are of assemblies reference.. right click on error line, click resolve and insert related assembly reference.

Angel Princess · Answer

from where selectall() some?? too much errors

Najjaf Shuja · Answer

private void ExportToExcel() { datagrid1.SelectAllCells(); datagrid1.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, datagrid1); String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); String result = (string)Clipboard.GetData(DataFormats.Text); datagrid1.UnselectAllCells(); System.IO.StreamWriter file = new System.IO.StreamWriter(@”C:\Users	est.xls”); file.WriteLine(result.Replace(‘,’, ‘ ‘)); file.Close(); MessageBox.Show(” Exporting DataGrid data to Excel file created”); }