如何通过VC读取EXCEL表格的数据? 各位朋友,我想知道的是通过什么方法能够知道一个已经存在的EXCEl文件中有几个sheet页?每个sheet页的名称是什么?谢谢高手解答!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 _Application m_oApp; Workbooks m_oBooks;_Workbook m_oBook;Worksheets m_oSheets;_Worksheet m_oSheet;m_oApp.CreateDispatch("Excel.Application",NULL);m_oBooks.AttachDispatch(m_oApp.GetWorkBooks());COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);//m_szFilePath--EXCEL文件路径lpDisp = m_oBooks.Open(m_szFilePath, covOptional, covOptional, covOptional, covOptional, covOptional,covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional); m_oBooks.AttachDispatch(lpDisp);m_oSheets.AttachDispatch(m_oBook.GetSheets());//获取sheet页的个数m_nSheet = m_oSheets.GetCount();CString* strSheetName;strSheetName = new CString[m_nSheet];for(i = 0; i < m_nSheet; i++){ m_oSheet.AttachDispatch(m_oSheets.GetItem(COleVariant((short)(i + 1)))); //各个Sheet的名字 strSheetName[i] = m_oSheet.GetName();} 重载"<<"报错,帮帮忙! 如何获取本机收到的数据包的IP? 如何获得韩文内容 MFC vs WTL? ■■■■■■■■谁会用面向对象的方式设计一矩阵的运算■■■■■■■■ ADO访问数据库,可否同时连接多个数据库? 急,在线等待! apihook的问题,高手给看看。 我想做这样的一个函数放在dll中,但vb调用时总是非法操作,请高手帮忙或给出例子 文件读为什么老是出错呢? 关于语音库的,急用......还望哪位大虾出手相救...小弟感激不尽..... CListCtrl显示图片问题 Invoke函数出错了
Workbooks m_oBooks;
_Workbook m_oBook;
Worksheets m_oSheets;
_Worksheet m_oSheet;
m_oApp.CreateDispatch("Excel.Application",NULL);
m_oBooks.AttachDispatch(m_oApp.GetWorkBooks());
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
//m_szFilePath--EXCEL文件路径
lpDisp = m_oBooks.Open(m_szFilePath, covOptional, covOptional, covOptional, covOptional, covOptional,covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional);
m_oBooks.AttachDispatch(lpDisp);
m_oSheets.AttachDispatch(m_oBook.GetSheets());
//获取sheet页的个数
m_nSheet = m_oSheets.GetCount();
CString* strSheetName;
strSheetName = new CString[m_nSheet];
for(i = 0; i < m_nSheet; i++)
{
m_oSheet.AttachDispatch(m_oSheets.GetItem(COleVariant((short)(i + 1))));
//各个Sheet的名字
strSheetName[i] = m_oSheet.GetName();
}