Datagridview to excel

Question

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

darjeam nh · 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”); }