描述:
如下的代码,在别人的例子中,我也试过来,用基于对话框的工程就很好,而后我移植到我的程序里,用菜单时间触发,结果创建Excel服务失败!总是会出来,而在对话框程序里面,用按钮时间触发,却创建EXCEL服务能成功,后面代码一切OK。
_Application ExcelApp;
Workbooks workBooks;
_Workbook workBook;
Worksheets workSheets;
_Worksheet workSheet;
Range range;
if ( !ExcelApp.CreateDispatch("Excel.Application",NULL))
{
AfxMessageBox("创建Excel服务失败!");
exit(1);
}
workBooks.AttachDispatch(ExcelApp.GetWorkbooks(),true);
workBook.AttachDispatch( workBooks.Add(
_variant_t("e:\\故障处理\\current.xls")));
workSheets.AttachDispatch( workBook.GetWorksheets());
workSheet.AttachDispatch( workSheets.GetItem(
_variant_t("sheet1")),true);
range.AttachDispatch( workSheet.GetCells(),true);
range.SetItem(_variant_t(long(1)),_variant_t(long(1)),
_variant_t("hello"));
workBook.Save();
ExcelApp.SetVisible(true);
range.ReleaseDispatch();
workSheet.ReleaseDispatch();
workSheets.ReleaseDispatch();
workBook.ReleaseDispatch();
workBooks.ReleaseDispatch();
ExcelApp.ReleaseDispatch();