求数据导出到excel方法

[Neky]

要是excel表不存在则自动生成excel文件并将数据导入到excel
各位高手有什么好的方法？

[jiezhi]

搜索，论坛上例子很多。

[jiezhi]

一个简单的：
private void button1_Click(object sender, System.EventArgs e)
{
Excel.Application myExcel = (Excel.Application)(new Excel.ApplicationClass());
myExcel.Application.Workbooks.Add(true);
myExcel.Visible = true;
// Title
myExcel.Cells[1,4] = txtTitle.Text;

//
string strField = "";
for(int i=0;i<listView.Items.Count;i++)
{
if(listView.Items[i].Checked)
{
strField = strField+listView.Items[i].Text + ",";
}
}
string strFields = "";
strFields = "," + strField;
int intRow = 3;
bool b = false;
foreach(DataRow dr in _PubDs.Tables[0].Rows)
{
int intCol = 1;
foreach(DataColumn dc in _PubDs.Tables[0].Columns)
{
if(strFields.IndexOf("," + dc.ColumnName + ",")>=0)
{
if(!b)
myExcel.Cells[2,intCol] = dc.ColumnName;
myExcel.Cells[intRow,intCol] = dr[dc.ColumnName].ToString();
intCol++;
}
}
b = true;
intRow++;
}

//myExcel.Save((object)(txtFile.Text));
}

[Neky]

请问有具体介绍的篇子吗？