- C# code
OLEObject ExcelServerValue = GetFileSaveName("选择或新建表格",routename, Filename, "xls", "Microsoft Excel(*.xls),*.xls,所有文件(*.*),*.*" )ExcelServer = CREATE OLEObjectExcelOK = ExcelServer.ConnectToNewObject( "excel.application" )ExcelServer.Workbooks.Add// ExcelServer.ActiveWorkbook.SaveAs(routename) 如果保存放这里,则写入的内容怎样保存?ExcelServer.ActiveWorkbook.Sheets(1).SELECT/*..............写入文档内容............*/ExcelServer.ActiveWorkbook.SaveAs(routename) //保存ExcelServer.Application.Visible = false //不打开ExcelServer.DisConnectObject()DESTROY ExcelServer
这个顺序写下来,有什么错误吗?
保存文件后,我发现进程并没有结束,当打开这个文件时,会提示已经打开,该怎样执行保存后关闭进程?
------解决方案--------------------
DESTROY ExcelServer
试一下前写上:
ExcelServer.Workbooks.close