求大神支招，用的visual studio 2013，excel 是2010的，我本想用excel 的.olb 文件，但是2010的没找到。目前只想打开某excel文件

顶一个

HRESULT hr;
hr = CoInitialize(NULL);
if(FAILED(hr))
{
AfxMessageBox(_T("Failed to call Coinitialize()" ));
}
CFileDialog filedlg(TRUE,L"*.xls",NULL,OFN_HIDEREADONLY|OFN_OVERWRITEPROMPT,L"Xls文件 (*.xls)|*.xls");
filedlg.m_ofn.lpstrTitle=L"打开文件";
CString strFilePath;
if (IDOK==filedlg.DoModal())
{
strFilePath=filedlg.GetPathName();
}
else
{
return;
}
//////////////////////////////////////////////////////////////////////////
CApplication app;
CWorkbook book;
CWorkbooks books;
CWorksheet sheet;
CWorksheets sheets;
CRange range;
LPDISPATCH lpDisp;
//定义变量
COleVariant covOptional((long)
DISP_E_PARAMNOTFOUND,VT_ERROR);
if (!app.CreateDispatch(_T("Excel.Application"),NULL))
{
this->MessageBox(_T("无法创建Excel应用"));
return;
}
books = app.get_Workbooks();
//打开Excel，其中pathname为Excel表的路径名
lpDisp = books.Open(strFilePath,covOptional
,covOptional,covOptional,covOptional,covOptional,covOptional,covOptional
,covOptional,covOptional,covOptional
,covOptional,covOptional,covOptional
,covOptional);

复制粘贴

直接打开文件啊