[//导出Excel
private void Export(DataSet ds)
{
System.Data.DataTable DT = ds.Tables[0];
string exportExcelPath = textBox4.Text + “\” + textBox2.Text.Substring(textBox2.Text.LastIndexOf(’\’) + 1);
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
//打开Excel
Microsoft.Office.Interop.Excel.Workbook xlsWorkBook = xlApp.Workbooks.Open(textBox2.Text);
//Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = xlsWorkBook.Worksheets[1];//取得sheet1
worksheet.Cells.NumberFormatLocal = "@";
//改变表头
//worksheet.Cells[0,0] = "";
//worksheet.Cells[1, 1] = "CBFBM";
//worksheet.Cells[1, 2] = "CBFMC";
//worksheet.Cells[1, 3] = "案卷号";
//写入数值
for (int i = 0; i < DT.Rows.Count; i++)
{
//worksheet.Cells[i + 2, 1] = int.Parse(DT.Rows[i][0].ToString()).ToString("0000");
//worksheet.Cells[i + 2, 2] = DT.Rows[i][1].ToString();
//if ("".Equals(DT.Rows[i][2].ToString()))
// worksheet.Cells[i + 2, 3] = "";
//else
// worksheet.Cells[i + 2, 3] = int.Parse(DT.Rows[i][2].ToString()).ToString("00000");
//System.Windows.Forms.Application.DoEvents();
worksheet.Cells[i + 2, comboBox5.SelectedIndex + 1] = DT.Rows[i][comboBox5.SelectedIndex].ToString();
System.Windows.Forms.Application.DoEvents();
}
Console.WriteLine(comboBox5.SelectedIndex);
worksheet.Columns.EntireColumn.AutoFit();//列宽自适应
//另存
xlsWorkBook.SaveAs(exportExcelPath);
//strConnection.Close();
//关闭Excel进程
xlApp.Quit();
}