Question

C#, 把access数据导出成excel表格

如果具体到查询结果呢？查询具体到某一个人的信息输出到特定表格Excal中
急求
谢谢

Answer 1

添加一个引用（micros excel）,然后添加如下代码：
Microsoft.Office.Interop.Excel.ApplicationClass myexcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
myexcel.Visible = true;
if (myexcel == null)
{
MessageBox.Show("无法启动excel");
return;
}
myexcel.Application.Workbooks.Add(true);
int rowscount = this.dataGridView1.RowCount;
int colcount = this.dataGridView1.ColumnCount;
for (int i = 0; i < colcount; i++)
{
myexcel.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText;
}
for (int i = 0; i < rowscount; i++)
{
for (int j = 0; j < colcount; j++)
{
myexcel.Cells[i + 2, j + 1] = this.dataGridView1[j,i].Value.ToString();
}
}