private void ToCsV(DataGridView
dGV, string filename)
{
string
stOutput = "";
// Export
titles:
string
sHeaders = "";
for
(int j = 0; j < dGV.Columns.Count; j++)
sHeaders = sHeaders.ToString()
+ Convert.ToString(dGV.Columns[j].HeaderText)
+ "\t";
stOutput += sHeaders + "\r\n";
// Export
data.
for
(int i = 0; i < dGV.RowCount - 1; i++)
{
string
stLine = "";
for
(int j = 0; j < dGV.Rows[i].Cells.Count;
j++)
stLine = stLine.ToString()
+ Convert.ToString(dGV.Rows[i].Cells[j].Value)
+ "\t";
stOutput += stLine + "\r\n";
}
Encoding
utf16 = Encoding.GetEncoding(1254);
byte[]
output = utf16.GetBytes(stOutput);
FileStream
fs = new FileStream(filename,
FileMode.Create);
BinaryWriter
bw = new BinaryWriter(fs);
bw.Write(output, 0, output.Length);
//write the encoded file
bw.Flush();
bw.Close();
fs.Close();
}
private void button2_Click(object
sender, EventArgs e)
{
SaveFileDialog
sfd = new SaveFileDialog();
sfd.Filter = "Excel Documents (*.xlsx)|*.xls";
sfd.FileName = "export.xls";
if
(sfd.ShowDialog() == DialogResult.OK)
{
//ToCsV(dataGridView1,
@"c:\export.xls");
ToCsV(dataGridView1,
sfd.FileName); // Here dataGridview1 is your grid
view name
}
}
Export Datagrid to Excel worksheet
(This Code is Working)
Before using this code must
add
Next we add a
reference to the Microsoft.Office.Interop DLL to our project from
"Project" -> "Add Reference".
5. Now we create an Object for the Excel Application using the
ApplicationClass.
Microsoft.Office.Interop.Excel.ApplicationClass XcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
6. Next, we create a new workbook using the Add method of the Object:
XcelApp.Application.Workbooks.Add(Type.Missing);
7. Now, we need to store the Header details for the DataGridView in Excel using
code as in the following:
for (int i = 1; i <
dataGridView1.Columns.Count + 1; i++)
{
XcelApp.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;
}
8. Next, we loop through the rows and columns of the dataGridView1 to store the
values in Excel.
for (int i = 0; i <
dataGridView1.Rows.Count; i++)
{
for (int j = 0; j <
dataGridView1.Columns.Count; j++)
{
XcelApp.Cells[i + 2, j + 1] =
dataGridView1.Rows[i].Cells[j].Value.ToString();
}
}
9. Here, next we set the properties of the Workbook column to AutoFit:
XcelApp.Columns.AutoFit();
10. Then we open Excel with the workbook using the Visible property as in the
following:
XcelApp.Visible = true;
11. Move to the Designer and click the Export button. Now, a new Excel workbook
is opened with the DataGridView details in it.
==============================================================================
if
(dataGridView1.Rows.Count > 0)
{
Microsoft.Office.Interop.Excel.ApplicationClass XcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
XcelApp.Application.Workbooks.Add(Type.Missing);
for
(int i = 1; i < dataGridView1.Columns.Count
+ 1; i++)
{
XcelApp.Cells[1, i] =
dataGridView1.Columns[i - 1].HeaderText;
}
for
(int i = 0; i < dataGridView1.Rows.Count;
i++)
{
for
(int j = 0; j < dataGridView1.Columns.Count;
j++)
{
XcelApp.Cells[i + 2, j
+ 1] = dataGridView1.Rows[i].Cells[j].Value.ToString();
}
}
XcelApp.Columns.AutoFit();
XcelApp.Visible = true;
}