请问!怎样在窗口里面插入一个exell表格,给个实例,给分100 例子:\VC98\ATL\ACTIVEDOC上哪吃 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 下面代码知识对EXCEL控制,并进行数据读写的例子,但愿给你有所帮助吧_Application m_app;Range m_range;_Worksheet m_worksheet;Workbooks m_workbooks;Worksheets m_worksheets; LPDISPATCH pDisp; LPUNKNOWN pUnk; CLSID clsid; BeginWaitCursor(); ::CLSIDFromProgID(L"Excel.Application.9",&clsid); if(::GetActiveObject(clsid,NULL,&pUnk)==S_OK) { VERIFY(pUnk->QueryInterface(IID_IDispatch,(void**)&pDisp)==S_OK); m_app.AttachDispatch(pDisp); pUnk->Release();} else { if(!m_app.CreateDispatch("Excel.Application.9")) { AfxMessageBox("Excel2000 program not found"); } TRACE("create complete\n"); } EndWaitCursor(); LPDISPATCH pWorkbooks; CWnd *pWnd=CWnd::FindWindow("XLMAIN",NULL); if(pWnd!=NULL) { TRACE("EXCEL WINDOW FOUND"); pWnd->ShowWindow(SW_SHOWNORMAL); pWnd->UpdateWindow(); pWnd->BringWindowToTop(); } VERIFY(pWorkbooks=m_app.GetWorkbooks()); m_workbooks.AttachDispatch(pWorkbooks); LPDISPATCH pWorkbook=NULL; m_app.SetVisible(FALSE); pWorkbook=m_workbooks.Add(COleVariant("c:\\1.csv")); LPDISPATCH pWorksheets=m_app.GetWorksheets(); ASSERT(pWorksheets!=NULL); m_worksheets.AttachDispatch(pWorksheets); LPDISPATCH pWorksheet=m_worksheets.GetItem(COleVariant((short)1)); m_worksheet.AttachDispatch(pWorksheet); m_worksheet.Activate(); m_range.AttachDispatch(m_worksheet.GetRange(COleVariant("A2"))); COleVariant vaResult=m_range.GetValue(); m_bochang=vaResult.dblVal; 谢谢!您能把完整的例子的源文件压缩后发给我吗?我的信箱:[email protected] 不好意思,我这是给公司作的软件,不能全部给你,你具体有什么问题可以给我E-MAIL[email protected] 请教一个WINDOWS7的问题 sendmessage不起作用 win32应用程序如何加启动参数 有没有对MBCS比较熟悉的?进来看看 stl中list问题!(up有分) 100分求VC6英文企业版,同时交友 求高手指点,怎样从局域网上拷贝文件夹? 怎样处理鼠标移动的消息? 以下代码竟然导致内存泄露,百思不得其解 我是女生,计算机专业的,刚刚毕业,对工作没有信心,求助! 如何选中用MFC函数画出的图形,并对其进行删除,复制,旋转和移动等操作。 请问各位高手怎样在对话框中作图,比如在对话框中画一条线。给点代码,谢谢
_Application m_app;
Range m_range;
_Worksheet m_worksheet;
Workbooks m_workbooks;
Worksheets m_worksheets; LPDISPATCH pDisp;
LPUNKNOWN pUnk;
CLSID clsid;
BeginWaitCursor();
::CLSIDFromProgID(L"Excel.Application.9",&clsid);
if(::GetActiveObject(clsid,NULL,&pUnk)==S_OK)
{
VERIFY(pUnk->QueryInterface(IID_IDispatch,(void**)&pDisp)==S_OK);
m_app.AttachDispatch(pDisp);
pUnk->Release();
}
else
{
if(!m_app.CreateDispatch("Excel.Application.9"))
{
AfxMessageBox("Excel2000 program not found");
}
TRACE("create complete\n");
}
EndWaitCursor();
LPDISPATCH pWorkbooks;
CWnd *pWnd=CWnd::FindWindow("XLMAIN",NULL);
if(pWnd!=NULL)
{
TRACE("EXCEL WINDOW FOUND");
pWnd->ShowWindow(SW_SHOWNORMAL);
pWnd->UpdateWindow();
pWnd->BringWindowToTop();
} VERIFY(pWorkbooks=m_app.GetWorkbooks());
m_workbooks.AttachDispatch(pWorkbooks);
LPDISPATCH pWorkbook=NULL;
m_app.SetVisible(FALSE);
pWorkbook=m_workbooks.Add(COleVariant("c:\\1.csv"));
LPDISPATCH pWorksheets=m_app.GetWorksheets();
ASSERT(pWorksheets!=NULL);
m_worksheets.AttachDispatch(pWorksheets);
LPDISPATCH pWorksheet=m_worksheets.GetItem(COleVariant((short)1));
m_worksheet.AttachDispatch(pWorksheet);
m_worksheet.Activate();
m_range.AttachDispatch(m_worksheet.GetRange(COleVariant("A2")));
COleVariant vaResult=m_range.GetValue();
m_bochang=vaResult.dblVal;
[email protected]