求问啊。C++读取EXCEL表格有哪几种实现方式啊?
并求具体的实现方法~~~
[解决办法]
推荐通过com接口
http://wenku.baidu.com/view/501dc9fc04a1b0717fd5ddf1.html
[解决办法]
ADO 方式,OLE方式等
[解决办法]
CDatabase database;
CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)";
CString sExcelFile;
CString sSql,instr;
sExcelFile = pathstr;
TRY
{
sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",sDriver, sExcelFile, sExcelFile);
int i=0,j;
if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
{
CString zdstr;
zdstr.Empty();
for(i=0;i<m_rpt.GetSubitemsCount();i++)
{
tmp = m_rpt.GetSubitemText(i);
zdstr +=tmp+ " TEXT,";
}
zdstr = zdstr.Left(zdstr.GetLength()-1);
sSql = "CREATE TABLE FitBill (" + zdstr +")";
database.ExecuteSQL(sSql);
for(i=0;i<m_rpt.GetItemCount();i++)
{
instr.Empty();
for(j=0;j<m_rpt.GetSubitemsCount();j++)
{
tmp = m_rpt.GetItemText(i,j);
instr += tmp+"','";
}
instr = instr.Left(instr.GetLength()-3);
sSql = "INSERT INTO FitBill VALUES ('" + instr +"')";
database.ExecuteSQL(sSql);
}
}
database.Close();
}
CATCH_ALL(e)
{
TRACE1("Excel驱动没有安装: %s",sDriver);
return;
}
END_CATCH_ALL;
[解决办法]
EXCEL的对象模型