| 关于用ADO.NET访问Excel数据的探究 |
| |
| 引用本文： | 陈思敏.关于用ADO.NET访问Excel数据的探究[J].广东教育学院学报,2007,27(5):91-95. |
| |
| 作者姓名： | 陈思敏 |
| |
| 作者单位： | 广东教育学院计算机科学系 广东广州510303 |
| |
| 摘 要： | Excel电子表格被广泛地用于记录和处理各种各样的数据,因此如何在应用程序里读取和处理Excel数据是软件开发人员经常遇到的问题.微软的ADO.NET提供了直接访问Excel数据的技术,这些技术包括OleCommand、OleDataReader、OleDataAdapter、OleDataSet等对象及其方法.利用ADO.NET的这些技术可以在应用程序里高效地灵活地读取和更新Excel数据.
|
| 关 键 词： | ADO.NET Excel 数据 读取 更新 |
| 文章编号： | 1007-8754（2007）05-0091-05 |
| 修稿时间： | 2007-07-11 |
A Research on the Technique of Accessing Excel Data with ADO.NET |
| |
| CHEN Si-min.A Research on the Technique of Accessing Excel Data with ADO.NET[J].Journal of Guangdong Education Institute,2007,27(5):91-95. |
| |
| Authors: | CHEN Si-min |
| |
| Institution: | Dept. of Computer Science, Guangdong Education Institute, Guangzhou, Guangdong, 510303, P. R. China |
| |
| Abstract: | The Spreadsheets of MS Excel are commonly used to record and manipulate various types of data,and therefore it is a problem faced by software developers frequently of how to retrieve data from Excel spreadsheets and manipulate it.The techniques of ADO.NET from MS provide methods to access the Excel data directly.These techniques include OleCommand,OleDataReader,OleDataAdapter,OleDataSet,etc.In these methods software developers can make their applications retrieve and update Excel data effectively and flexibly. |
| |
| Keywords: | ADO NET Excel data retrieve update |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
