3,245
社区成员
发帖
与我相关
我的任务
分享
void COfficeTestDlg::OnBnClickedOk()
{
// TODO: Add your control notification handler code here
CApplication oApp;
oApp.CreateDispatch(_T("Excel.Application"));
CWorkbooks books;
books = oApp.get_Workbooks();
CWorkbook book;
book = books.Open(_T("E:\\test.xls"), vtMissing,vtMissing, vtMissing, vtMissing, vtMissing, vtMissing,vtMissing, vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing );
CWorksheets sheets;
sheets = book.get_Worksheets();
CWorksheet sheet;
sheet = sheets.get_Item(_variant_t((LONG)1));
CRange range;
range = sheet.get_Range(_variant_t("B4"),vtMissing);
CRange rangV;
rangV.AttachDispatch(range.get_Item(_variant_t((LONG)1), _variant_t((LONG)2)).pdispVal);
_variant_t value = rangV.get_Value2();
rangV.ReleaseDispatch();
range.ReleaseDispatch();
sheet.ReleaseDispatch();
sheets.ReleaseDispatch();
book.ReleaseDispatch();
books.Close();
books.ReleaseDispatch();
oApp.Quit();
oApp.ReleaseDispatch();
//OnOK();
}
oApp.CreateDispatch("Excel.Application",NULL);
oApp.Quit();
oApp.ReleaseDispatch();
oApp.CreateDispatch("Excel.Application",NULL);
oWorkbooks=oApp.GetWorkbooks();
oWorkbooks.ReleaseDispatch();
oApp.Quit();
oApp.ReleaseDispatch();
oApp.CreateDispatch("Excel.Application",NULL);
oWorkbooks=oApp.GetWorkbooks();
oWorkbook=oWorkbooks.Open(pFilename,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing);
oWorkbook.ReleaseDispatch();
oWorkbooks.Close();
oWorkbooks.ReleaseDispatch();
oApp.Quit();
oApp.ReleaseDispatch();