试一下这个
Excel.ApplicationClass eExcel=new Excel.ApplicationClass ();
Excel.Workbook eWorkbook=eExcel.Workbooks.Add(true);
Excel.Worksheet eWorksheet=(Excel.Worksheet)eWorkbook.Sheets.get_Item(1);
int k=1;
foreach(DataColumn dc in dt.Columns)
{
eWorksheet.Cells[1,k]=dc.ColumnName;
k++;
} int eR=2;
foreach(DataRow dr in dt.Rows)
{
this.statusBar1.Text="正在存盘,请稍候.... "+dt.Rows.Count.ToString ()+":"+(eR-1).ToString ();
k=1;//列
foreach(DataColumn dc in dt.Columns)
{
eWorksheet.Cells[eR,k]=dr[dc].ToString().Trim();
k++;
}
eR++;//行
} eWorkbook.SaveAs(FileName,Missing.Value,null,null,Missing.Value,Missing.Value,Excel.XlSaveAsAccessMode.xlExclusive,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
eExcel.Quit();
Excel.ApplicationClass eExcel=new Excel.ApplicationClass ();
Excel.Workbook eWorkbook=eExcel.Workbooks.Add(true);
Excel.Worksheet eWorksheet=(Excel.Worksheet)eWorkbook.Sheets.get_Item(1);
int k=1;
foreach(DataColumn dc in dt.Columns)
{
eWorksheet.Cells[1,k]=dc.ColumnName;
k++;
} int eR=2;
foreach(DataRow dr in dt.Rows)
{
this.statusBar1.Text="正在存盘,请稍候.... "+dt.Rows.Count.ToString ()+":"+(eR-1).ToString ();
k=1;//列
foreach(DataColumn dc in dt.Columns)
{
eWorksheet.Cells[eR,k]=dr[dc].ToString().Trim();
k++;
}
eR++;//行
} eWorkbook.SaveAs(FileName,Missing.Value,null,null,Missing.Value,Missing.Value,Excel.XlSaveAsAccessMode.xlExclusive,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
eExcel.Quit();
不行啊,
报错:重载“SaveAs”方法未获取“1”参数
eWorkbook.Save();
大概可以,我也没有试过,猜的
无法对属性或索引器“Excel._Workbook.FullName”赋值 -- 它是只读的
dt是什么啊,请指教一下,不胜感激!