导出数据表(Excel)
首先要添加一个引用:using system.Excel(似乎是这个)
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = true;
for (int i = 0; i < this.dataGridView1.ColumnCount; i++)
{
excel.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText;
}
for (int i = 0; i < this.dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
{
excel.Cells[i + 2, j + 1] = this.dataGridView1[j, i].Value.ToString();
}
}
努力、努力、加油!