CSpreadSheet
CSpreadSheetEXCELEXCELODBCEXCELFROM。
MFC () .Unicode。ODBC
ExcelODBC.Excel。()。
. . Excel。http://blog.csdn.net/andy205214/article/details/5918648
12345678910111213141516171819202122 <代码类=癱pp空间”>,, <代码类=癱pp平原”> CDatabase 数据库; <代码类=" cpp评论">//数据库库需要包含头文件# include & lt; afxdb.h> <代码类=癱pp空间”>,, <代码类=癱pp平原”> CString sDriver =, _T( <代码类=" cpp字符串"> " MICROSOFTEXCEL DRIVER (* xls)" <代码类=" cpp平原">); <代码类=" cpp评论">//,Excel驱动 <代码类=癱pp空间”>,, <代码类=癱pp平原”> CString sSql; <代码类=癱pp空间”>,, <代码类=癱pp平原”> charszRecord [6] [128],=, {0},,, sSql。代码格式(_T( <代码类=癱pp字符串”>“司机={% s}; DSN="; FIRSTROWHASNAMES=1;只读的=FALSE; CREATE_DB=\ " % s \ "; DBQ=% s " <代码类=" cpp平原">),sDriver, strFilePath,, strFilePath); <代码类=癱pp空间”>,, <代码类=" cpp字大胆">如果 <代码类=癱pp平原”> (! db.OpenEx (sSql CDatabase:: noOdbcDialog)) <代码类=" cpp评论">//连接数据源DJB。xls <代码类=癱pp空间”>,, <代码类=癱pp平原”>{ <代码类=癱pp空间”>,,,, <代码类=癱pp平原”>弹出窗口(_T( <代码类=" cpp字符串"> "打开EXCEL文件失败!" <代码类=" cpp平原">),_T( <代码类=癱pp字符串”>“错误” <=癱pp平原”>代码类)); <代码类=癱pp空间”>,,,, <代码类=" cpp字大胆">返回 <代码类=癱pp平原”>, <代码类=癱pp空间”>,, <代码类=癱pp平原”>} <代码类=癱pp空间”>,, <代码类=" cpp评论">//打开EXCEL表 <代码类=癱pp空间”>,, <代码类=癱pp平原”> CRecordset pset(和db); <代码类=癱pp空间”>,, <代码类=癱pp平原”> sSql。代码格式(_T( <代码类=癱pp字符串”>“SELECTvalues1 values2 得到Sheet1” <=癱pp平原”>代码类)); <代码类=癱pp空间”>,, <代码类=癱pp平原”> pset.Open (CRecordset:: forwardOnly、sSql CRecordset::只读的); <代码类=癱pp空间”>,, <代码类=" cpp字大胆">, <代码类=癱pp平原”> (! pset.IsEOF()) <代码类=癱pp空间”>,, <代码类=癱pp平原”>{ <代码类=癱pp空间”>,,,, <代码类=癱pp平原”> pset.GetFieldValue(); <代码类=" cpp评论">//前面字段代码 <代码类=癱pp空间”>,,,, <代码类=癱pp平原”> pset.MoveNext(); <代码类=癱pp空间”>,, <代码类=癱pp平原”>} <代码类=癱pp空间”>,, <代码类=癱pp平原”> db.Close();
