求一段用EXCEL.DLL将数据导出到EXCEL的代码！！！

[xinxincao]

excelapp.Quit();
excelapp = null;
GC.Collect();

我用这种方法总是关不掉EXCEL.EXE进程，生成的文件也无法点开。

[acewang]

http://www.aspxcn.com/dotnetarticle/html/97.html

[孟子E章]

Process.Kill()

[xinxincao]

Object Nothing=System.Reflection.Missing.Value;
Excel.Application excelapp = new Excel.ApplicationClass();
Excel.Workbook oBook = excelapp.Workbooks.Add(true);
Excel.Worksheet oSheet = (Excel.Worksheet)oBook.Worksheets.Add( Nothing, Nothing, Nothing, Nothing);
oSheet.Cells[1,1] = "sss";
oBook.SaveAs(@"E:\\test.xls",Nothing,Nothing,Nothing,Nothing,Nothing,Excel.XlSaveAsAccessMode.xlNoChange
,Nothing,Nothing,Nothing,Nothing);
oBook.Close(Nothing,Nothing,Nothing);
excelapp.Quit();
oSheet = null;
oBook = null;
excelapp = null;

执行到oBook.SaveAs一句就执行不下去了，？？？？？？？

[xinxincao]

请大家关注一下！

[xinxincao]

怎么问了几天也没人帮帮忙！！！

[dongbeiren]

Dim process As System.Diagnostics.Process
For Each process In System.Diagnostics.Process.GetProcesses
If process.ProcessName = "EXCEL" Then
process.Kill()
End If
Next

[lucidaxy]

有没有更好的方法？不可以主动释放吗？

[zhyx21century]

use owc
SpreadsheetClass xlsheet = new SpreadsheetClass();
cnn.Open();
SqlDataReader reader = this.sql.ExecuteReader();
int numbercols = reader.FieldCount;
int row=1;
while (reader.Read())
{
for (int i=0;i<numbercols;i++)
{
xlsheet.ActiveSheet.Cells[row,i+1] = reader.GetValue(i).ToString();
}
row++;
}
reader.Close();
cnn.Close();
xlsheet.ActiveSheet.Export(Server.MapPath(".")+"\\"+this.xlfile.Text,OWC.SheetExportActionEnum.ssExportActionNone);

[xinxincao]

to zhyx21century(不想去编程)
用OWC那个库生成的东西不是真正的电子表格，在导入时，不能被识别；

to dongbeiren() ( )
现在的问题是，在任务管理器里手工都杀不掉这个进程，我试了你的代码，也行不通


继续问！！！