1、添加Microsoft.Office.Interop.Excel.DLL
步骤:1、选中“依赖项”点击右键-->选择“管理NuGet程序包”点击进入。
搜索Microsoft.Office.Interop.Excel,选择安装最新稳定版
2、创建Excel表格
Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
myExcel.Workbooks.Add(true);
myExcel.Visible = true;
3、遍历DataGridView将数据装入EXCEL
for (i = 0; i < dataGridView1.ColumnCount; i++)
{
myExcel.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;
}
for (i = 0; i < dataGridView1.RowCount; i++)
{
for (j = 0; j < dataGridView1.ColumnCount; j++)
{
myExcel.Cells[i + 2, j + 1] = "'" + dataGridView1[j, i].Value.ToString();
}
}
4、推出Excel并清空;
myExcel.Quit();
myExcel = null;
总结:
if (dataGridView1.Rows.Count == 0)
{
return;
}
Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
myExcel.Workbooks.Add(true);
myExcel.Visible = true;
for (i = 0; i < dataGridView1.ColumnCount; i++)
{
myExcel.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;
}
for (i = 0; i < dataGridView1.RowCount; i++)
{
for (j = 0; j < dataGridView1.ColumnCount; j++)
{
myExcel.Cells[i + 2, j + 1] = "'" + dataGridView1[j, i].Value.ToString();
}
}
myExcel.Quit();
myExcel = null;
一个函数搞定