Showing posts with label Microsoft Excel. Show all posts
Showing posts with label Microsoft Excel. Show all posts

2009-04-05

Reading an Excel spreadsheet using ADO.NET

Sample code illustrating how to connect to an Excel spreadsheet data source using ADO.NET.

The binary can be used to test connecting to spreadsheets; it supports sheets, sheets with ranges, and named ranges. Arbitrary select statements may be executed; the results are displayed along with the connection string used.

Supports Excel 5.0, 95, 97, 2000, 2003, and 2007 (all three variants). Comments in the code point to additional resources.

http://code.msdn.microsoft.com/NitoExcel