111,098
社区成员




string szConnection;
szConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fullPath + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'";
Microsoft.Office.Interop.Excel.ApplicationClass myExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();//创建对象
myExcel.Application.Workbooks.Add(true);//增加工作表
//添加字段名
for (int i = 0; i < listView1.Columns.Count; i++)
{
string name = listView1.Columns[i].Text.ToString();
myExcel.Cells[1, i + 1] = name;
}
//增加记录
for (int i = 0; i < listView1.Items.Count; i++)
{
myExcel.Cells[i + 2, 1] = listView1.Items[i].Text;//第一列
for (int j = 1; j < listView1.Columns.Count; j++)//后几列
{
myExcel.Cells[i + 2, j + 1] = listView1.Items[i].SubItems[j].Text;
}
}
myExcel.Visible = true;//打开Excel