使用Microsoft Visual C ++ 6.0的MFC在Excel WorkBook中创建报告 [英] Create Reports in Excel WorkBook using MFC of Microsoft Visual C++ 6.0

问题描述

我正在尝试使用
在excel工作簿中创建报告 MFC Visual C ++ 6.0.

有可能吗?
如果是，如何?

在此先感谢:)

Hi I''m trying to create a reports in excel workbook using
the MFC Visual C++ 6.0 .

Is that possible?
if yes, How?

Thanks in advance :)

推荐答案

您有多种选择:

• 将OLE Dispatch与Excel类型库一起使用.这需要在运行应用程序的计算机上安装一个Excel，并在开发计算机上安装Excel类型库.
  
• 使用ODBC.开放式数据库连接性是一种独立于操作系统的数据库管理标准.借助Excel ODBC驱动程序，它可以用于读取和写入Excel文件.因为它是数据库接口，所以它可以处理来自Excel文件的表格，例如数据库文件中的表格. Windows安装程序安装了必需的Excel ODBC驱动程序.
  
• 使用ADO(OLE DB). ActiveX Data Objects就像ODBC的数据库接口一样，处理来自Excel文件的表格，例如数据库文件中的表格.它比ODBC更新.这需要Windows安装程序安装ADO DLL. ADO还可用于使用具有不同连接字符串的ODBC驱动程序连接到Excel文件.
  
• 使用提供读写Excel文件的库.例如，LibXL(商业)[ ^ ]，BasicExcel [ ^ ]和BasicExcel派生ExcelFormat库[

You have multiple options:

• Using OLE Dispatch with the Excel type library. This requires an installed Excel on the machine running your application and the Excel type library on the development machine.
  
• Using ODBC. Open Database Connectivity is an operating system independent standard for database management. With Excel ODBC drivers, it can be used to read and write Excel files. Because it is a database interface, it handles sheets from an Excel file like tables in a database file. The required Excel ODBC driver is installed by the Windows Setup.
  
• Using ADO (OLE DB). ActiveX Data Objects is like ODBC a database interface, handling sheets from an Excel file like tables in a database file. It is more up-to-date than ODBC. This requires the ADO DLL wich is installed by Windows Setup. ADO may be also used to connect to Excel files using the ODBC drivers using a different connect string.
  
• Using a library that provides reading and writing Excel files. Examples are LibXL (commercial) [^], BasicExcel [^], and the BasicExcel derivation ExcelFormat Library [^].
  
• Writing data to CSV text files that can be opened with Excel.

您是否知道此站点[ ^ ]

查看我在网上获得的这些链接[

Are you aware of this site [^]

Look at these links which i got in the net [^]

这篇关于使用Microsoft Visual C ++ 6.0的MFC在Excel WorkBook中创建报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！