16,548
社区成员




try
{
CWaitCursor wait;
//变量定义
_Application app;
Workbooks books;
_Workbook book;
Worksheets sheets;
_Worksheet sheet;
//Range range, rangetot;
//Range iCell;
LPDISPATCH lpDisp;
COleVariant vResult;
COleVariant
covTrue((short)TRUE),
covFalse((short)FALSE),
covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
//////////////////////////////////////////////////////////////////////////
//初始化COM的动态连接库
CoInitialize(NULL);
/*
if(!AfxOleInit())
{
//AfxMessageBox(_T("无法初始化COM的动态连接库!"));
AfxMessageBox(_T("Initializtion COM DLL failing!"));
return FALSE;
}
*/
//////////////////////////////////////////////////////////////////////////
//创建Excel 2000服务器(启动Excel)
if(!app.CreateDispatch(_T("Excel.Application")))
{
//AfxMessageBox(_T("无法启动Excel服务器!"));
AfxMessageBox(_T("Initializtion Excel failing!"));
return FALSE;
}
//app.SetVisible(TRUE); //使Excel可见
//app.SetUserControl(TRUE); //允许其它用户控制Excel
//////////////////////////////////////////////////////////////////////////
//打开c:\1.xls
books.AttachDispatch(app.GetWorkbooks());
//lpDisp = books.Add(COleVariant(""));
lpDisp = books.Add(COleVariant((long)1));