文件名称:OpenExcel
- 所属分类:
- Windows编程
- 资源属性:
- [Windows] [Visual.Net] [源码]
- 上传时间:
- 2014-04-21
- 文件大小:
- 270kb
- 下载次数:
- 0次
- 提 供 者:
- bpu***
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
MFC_列表CListCtrl读写Excel文件,刚写完,亲测可用,不懂可学一下CListCtrl的用法。介绍一下:输入excel文件到列表&&输出列表到excel文件,需要1、向项目工程中添加基本的7个类,分别是:CApplication,CMyFont,CRange,CWorkBook,CWorkBooks,CWorkSheet,CWorkSheets,选择MFC Class From TypeLib,在Add Class From 中选中File,在Location中输入或者选择EXCEL.EXE(officer2007为EXCEL.EXE,officer2003为EXCEL9.OLB)的路径。然后在Interface框(即1号框)中选择操作Excel的基本接口,分别是:_Application,_WorkBook,_WorkSheet, Range,Font,WorkBooks,WorkSheets。点击Generated classes(即2号框)中CFont0类,在classes(即3号框)和File(即4号框)中修改其类名为CMyFont,头文件名为CMyFont.h(类名和头文件名,也可以是其他名字,由自己确定)。点击Finish完成添加-MFC_ list CListCtrl read and write Excel files, just finished, pro-test is available, do not know can learn about CListCtrl usage. Introduction: input excel file to the list && output list to excel file, you need an add basic seven categories in the project, namely: CApplication, CMyFont, CRange, CWorkBook, CWorkBooks, CWorkSheet, CWorkSheets, select MFC Class From TypeLib, select the Add Class From the File, enter or select EXCEL.EXE in Location (officer2007 as EXCEL.EXE, officer2003 as EXCEL9.OLB) path. And select Options in Excel Interface box (ie the 1st box) basic interface, namely: _Application, _WorkBook, _WorkSheet, Range, Font, WorkBooks, WorkSheets. Click the Generated classes (ie the 2nd box) CFont0 class, modify its kind in classes (ie the 3rd fr a me) and File (ie the 4th box) named CMyFont, header file called CMyFont.h (the class name and the name of the header file , other names may be determined by their own). Click Finish to add
(系统自动生成,下载前可以参看下载内容)
下载文件列表
OpenExcel\MFC列表与excel文件的通信.docx
.........\OpenExcel\CApplication.h
.........\.........\CFont0.h
.........\.........\CGlobal.h
.........\.........\CRange.h
.........\.........\CSheets.h
.........\.........\CWorkbook.h
.........\.........\CWorkbooks.h
.........\.........\CWorksheet.h
.........\.........\CWorksheets.h
.........\.........\OpenExcel.aps
.........\.........\OpenExcel.cpp
.........\.........\OpenExcel.h
.........\.........\OpenExcel.rc
.........\.........\OpenExcel.vcxproj
.........\.........\OpenExcel.vcxproj.filters
.........\.........\OpenExcel.vcxproj.user
.........\.........\OpenExcelDlg.cpp
.........\.........\OpenExcelDlg.h
.........\.........\ReadMe.txt
.........\.........\res\OpenExcel.ico
.........\.........\...\OpenExcel.rc2
.........\.........\resource.h
.........\.........\stdafx.cpp
.........\.........\stdafx.h
.........\.........\targetver.h
.........\OpenExcel.sln
.........\OpenExcel.suo
.........\说明.txt
.........\ipch\openexcel-49752cfa
.........\OpenExcel\Debug
.........\.........\res
.........\Debug
.........\ipch
.........\OpenExcel
OpenExcel