VC中获取Excel中的数据

来源：互联网发布：网络编程教程编辑：程序博客网时间：2024/05/20 14:18

if(MessageBox("请选择黑名单数据库！！","提示",MB_YESNO)==IDYES){char Filter[]="excel文件(*.xls)|*.xls||";CFileDialog dlgOpen(TRUE,0,0,OFN_HIDEREADONLY|OFN_FILEMUSTEXIST,(LPCTSTR)Filter,NULL);if(dlgOpen.DoModal()==IDOK){m_jiangsu_path=dlgOpen.GetPathName();}else{EndDialog(0);return false;}}else{EndDialog(0);return false;}if(!readexcel.OpenExcel(m_jiangsu_path)){MessageBox("连接excel类型的黑名单数据库没有成功");EndDialog(0);return FALSE;}

//从excel中查询是否为黑名单数据
BOOL CDlg::SearchExcelHmd(CString car_number, CString number_color){ if(strlen(car_number)<3)  return FALSE;    BOOL is_in_hmd=FALSE;     car_number="%"+car_number+"%"; try {  CString sSql;  sSql.Format("select * from [sheet1$] where HPHM like '%s'",car_number);  is_in_hmd=readexcel.SelectExcel(sSql);   } catch (CDBException* e) {  MessageBox("无法打开黑名单数据库！","提示：");    MessageBox(e->m_strError,"提示：");    return FALSE; }    // return is_in_hmd; return 0;
}