| Delphi操作ADO、ADOX存取和管理Excel |
| |
| 引用本文： | 周振红,余明辉,杨国录. Delphi操作ADO、ADOX存取和管理Excel[J]. 武汉大学学报(工学版), 2004, 37(4): 94-96 |
| |
| 作者姓名： | 周振红 余明辉 杨国录 |
| |
| 作者单位： | 1. 郑州大学环境与水利学院,河南,郑州,450002
2. 武汉大学水利水电学院,湖北,武汉,430072 |
| |
| 基金项目： | 国家自然科学基金(50209012)，河南省高校青年骨干教师资助项目. |
| |
| 摘 要： | 开发以Excel为数据源的应用程序,便于对日常工作进行管理,通过MicrosoftJet4.00LEDBProvider接口,运用Delphi的ADO组件、将其数据集的命令类型设为SQL语句,便可访问Excel工作表;Delphi对ADOX对象模型包装后,通过包装类来创建和修改Excel工作表结构.Excel作为以Jet为引擎的桌面数据库对待,在操作上须进行一些特殊的处理.
|
| 关 键 词： | Delphi ADO ADOX Excel OLEDBProvider |
| 文章编号： | 1671-8844(2004)04-094-03 |
| 修稿时间： | 2003-06-15 |
Deplhi processing the sheet of Excel by ADO and ADOX |
| |
| ZHOU Zhen-hong,YU Ming-hui,YANG Guo-lu. Deplhi processing the sheet of Excel by ADO and ADOX[J]. Engineering Journal of Wuhan University, 2004, 37(4): 94-96 |
| |
| Authors: | ZHOU Zhen-hong YU Ming-hui YANG Guo-lu |
| |
| Affiliation: | ZHOU Zhen-hong~1,YU Ming-hui~2,YANG Guo-lu~2 |
| |
| Abstract: | The application of Excel served as data source provides the convenience for routine maintenance. Through Microsoft Jet 4.0 OLE DB Provider, Access to Excel is implemented by ADO components of Delphi, CommandType of TADODataSet component being set as cmdText. The sheet of Excel can be created and modified by way of the wrapper of ADOX in Delphi. However, stress should be laid on specific processing of Excel served as desktop database. |
| |
| Keywords: | Delphi ADO ADOX Excel OLE OB Provider |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
