MFC,open函数错误请指教
COleVariant
covTrue((short)TRUE),
covFalse((short)FALSE),
covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
if(!excelapp.CreateDispatch("Excel.Application"))
{
MessageBox("确认是否安装了Excel");
}
books.AttachDispatch(excelapp.GetWorkbooks());
//打开Excel
lpDisp = books.Open(strFilePath,covOptional,covOptional,covOptional,covOptional,covOptional,covOptional,
covOptional,covOptional,covOptional,covOptional,covOptional,
covOptional);
红色标注的函数不能通过,这是我看网上一个文章拷的代码,但是在我的机器上不能通过编译,为什么?莫非是这个函数使用有有问题?
我在做VC读取excel文件,哪位大侠有源码给我发一下谢谢了!
我的邮箱:markfilan@hotmail.com。
[解决办法]
把编译错误内容贴出来吧。
[解决办法]
http://www.google.com/codesearch
[解决办法]
_Application App;
Workbooks workbooks;
_Workbook workbook;
Worksheets sheets;
_Worksheet sheet;
Range range;
OpenExcel
(
CString& ExtPath /*<I>*/
)
{
workbooks.AttachDispatch(App.GetWorkbooks(),true);
if(ExtPath.IsEmpty())
{
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
workbook.AttachDispatch(workbooks.Add(covOptional));
}
else
{
workbook.AttachDispatch(workbooks.Add(_variant_t(ExtPath)));
}
sheets.AttachDispatch(workbook.GetWorksheets(),true);
App.SetVisible(visible)
}
[解决办法]
这样就应该差不多了把....显示一个excel是没问题的了
App.SetVisible(true) 应该是这样