使用C++ 将数据导入excel

1、设置环境：Windows7Microsoft Visual Studio 2010Microsoft Office Excel 2003说明：用的公司的电脑，操作系统和软件都是正版的。

3、修改头文件进入刚添加进来的几个类头文件中将#import开头的这句注掉修改提示的错误将修改过的工程编译一下，出现如下错误：双击提示，在DialogBox（）前加下划线，如图：

5、导出附录一： 导出Excel格式的简单流程CFileDialog dlg(FALSE,_T("(*.xls)"),NULL,OFN_HIDEREADONLY |OFN_OVERWRITEPROMPT,_T("(*.xls)|*.xls||"),NULL);if (dlg.DoModal() == IDOK){//获取路径CString strFileName=dlg.GetPathName(); COleVariant covTrue((short)TRUE), covFalse((short)FALSE), covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); CApplication0 app; CWorkbook0 book; CWorkbooks0 books; CWorksheet0 sheet; CWorksheets0 sheets; CRange0 range; CFont1 font; if (!app.CreateDispatch(_T("Excel.Application"))) { MessageBox(_T("Error!")); } books = app.get_Workbooks(); book = books.Add(covOptional); sheets = book.get_Worksheets(); sheet = sheets.get_Item(COleVariant((short)1)); range = sheet.get_Range(COleVariant(_T("A1")),COleVariant(_T("A1"))); range.put_Value2(COleVariant(_T("hanhan"))); book.SaveCopyAs(COleVariant(strFileName)); book.put_Saved(true); book.ReleaseDispatch(); books.ReleaseDispatch(); app.Quit(); app.ReleaseDispatch();}