摘要
开发以Excel为数据源的应用程序,便于对日常工作进行管理,通过MicrosoftJet4.00LEDBProvider接口,运用Delphi的ADO组件、将其数据集的命令类型设为SQL语句,便可访问Excel工作表;Delphi对ADOX对象模型包装后,通过包装类来创建和修改Excel工作表结构.Excel作为以Jet为引擎的桌面数据库对待,在操作上须进行一些特殊的处理.
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.
出处
《武汉大学学报（工学版）》
CAS
CSCD
北大核心
2004年第4期94-96,共3页
Engineering Journal of Wuhan University
基金
国家自然科学基金(50209012)
河南省高校青年骨干教师资助项目.
