关于用ADO.NET访问Excel数据的探究

A Research on the Technique of Accessing Excel Data with ADO.NET

Excel电子表格被广泛地用于记录和处理各种各样的数据,因此如何在应用程序里读取和处理Excel数据是软件开发人员经常遇到的问题.微软的ADO.NET提供了直接访问Excel数据的技术,这些技术包括OleCommand、OleDataReader、OleDataAdapter、OleDataSet等对象及其方法.利用ADO.NET的这些技术可以在应用程序里高效地灵活地读取和更新Excel数据.

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.