Datagridview to excel

Please refer to this link:

 

 

Hope it helps

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)
        {

excelSheet.Cells[1, 2] = "Date : " + DateTime.Now.ToShortDateString();

 

int rowcount = 2;

foreach (DataRow datarow in dataTable.Rows)
{
rowcount += 1;
for (int i = 1; i <= dataTable.Columns.Count; 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(); 

}

 giving errors check zip file

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\test.xls”);
file.WriteLine(result.Replace(',', ' '));
file.Close();

MessageBox.Show(" Exporting DataGrid data to Excel file created");

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 <= DataGrid.Columns.Count - 1; x++) {
_mFileStream.WriteLine(" ", DataGrid.Columns.Item(x).Width);
}
_mFileStream.WriteLine(" ");
for (int i = 0; i <= DataGrid.Columns.Count - 1; i++) {
_mFileStream.WriteLine(" ");
_mFileStream.WriteLine(string.Format(" {0}", DataGrid.Columns.Item(i).HeaderText));
_mFileStream.WriteLine("");
}
_mFileStream.WriteLine(" ");
for (int intRow = 0; intRow <= DataGrid.RowCount - 2; intRow++) {
_mFileStream.WriteLine(string.Format(" ", DataGrid.Rows(intRow).Height));
for (int intCol = 0; intCol <= DataGrid.Columns.Count - 1; 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) {
}
}

 

ExportToExcel(FilePath, DataGrid, "Sheet1")