1:导入excel.h和excel.cpp(可以从系统中找出的)
2:在当前文件夹中加头文件#include "excel.h"
3:在StdAfx.h中加入
#import "C:\Program Files\Common Files\System\ado\msado15.dll"
no_namespace rename("EOF","rsEOF")
4:在初始化中加入
if(CoInitialize(NULL)!=0)
{
AfxMessageBox( "初始化COM支持库失败! ");
exit(1);
}
来初始化COM;
5:主体操作
CString strname;
CString str;
CFileDialog dlg(true,NULL,NULL,OFN_FILEMUSTEXIST| OFN_HIDEREADONLY,"xls 文档 | *.xls||",this);
if(dlg.DoModal())
{
strname=dlg.GetPathName();
}
_Application exlapp;
_Workbook wbk;
Workbooks wbks;
_Worksheet wht;
Worksheets whts;
LPDISPATCH lpDisp; //lpdispatch
COleVariant covTrue((short)TRUE),covFalse((short)FALSE),\
covOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
if(!exlapp.CreateDispatch("Excel.Application",NULL))
{
MessageBox(_T("无法启动 Excel 服务器!"));
return;
}
..............
2:在当前文件夹中加头文件#include "excel.h"
3:在StdAfx.h中加入
#import "C:\Program Files\Common Files\System\ado\msado15.dll"
no_namespace rename("EOF","rsEOF")
4:在初始化中加入
if(CoInitialize(NULL)!=0)
{
AfxMessageBox( "初始化COM支持库失败! ");
exit(1);
}
来初始化COM;
5:主体操作
CString strname;
CString str;
CFileDialog dlg(true,NULL,NULL,OFN_FILEMUSTEXIST| OFN_HIDEREADONLY,"xls 文档 | *.xls||",this);
if(dlg.DoModal())
{
strname=dlg.GetPathName();
}
_Application exlapp;
_Workbook wbk;
Workbooks wbks;
_Worksheet wht;
Worksheets whts;
LPDISPATCH lpDisp; //lpdispatch
COleVariant covTrue((short)TRUE),covFalse((short)FALSE),\
covOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
if(!exlapp.CreateDispatch("Excel.Application",NULL))
{
MessageBox(_T("无法启动 Excel 服务器!"));
return;
}
..............