ATL
关于CWorkBooks的Open出错
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区[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();
程序就崩了。
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();
程序就崩了。
...全文
