关于CWorkBooks的Open出错
[align=left]// open the specified workbook
TRY
{
// Get Workbooks collection.
LPDISPATCH lpDisp;
lpDisp = m_pData->m_App.get_Workbooks(); // Get an IDispatch pointer
ASSERT(lpDisp);
m_pData->m_WorkBooks.AttachDispatch( lpDisp ); // Attach the IDispatch pointer to the books object.
// open the document
lpDisp = m_pData->m_WorkBooks.Open(CString(m_pData->m_strExcelPath.c_str()),
m_pData->m_CovOptional, m_pData->m_CovOptional, m_pData->m_CovOptional, m_pData->m_CovOptional,
m_pData->m_CovOptional, m_pData->m_CovOptional, m_pData->m_CovOptional, m_pData->m_CovOptional,
m_pData->m_CovOptional, m_pData->m_CovOptional, m_pData->m_CovOptional, m_pData->m_CovOptional
);
ASSERT(lpDisp);
//Set CWorkbook to use lpDisp, the IDispatch* of the actual workbook.
m_pData->m_WorkBook.AttachDispatch(lpDisp);
}
//Clean up if something went wrong.
CATCH(CException, e)
{
MessageBox(0,TEXT("Could not open workbork."), TEXT("Error"), MB_OK | MB_ICONERROR);
return;
}
程序跑到Open的时候,出来后执行Assert就执行MessageBox(0,TEXT("Could not open workbork.")。请问,哪里错了??
程序还是照样能往下跑。Excel也是照样能打开。
但跑到// get the selected worksheet
sheets = m_pData->m_WorkBook.get_Worksheets();
程序就崩了。