Search Wiki:
Resource Page Description
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.

Screenshot
Screenshot of NitoExcel
Last edited Dec 31 2008 at 11:29 PM  by StephenCleary, version 4
Comments
rwishlaw wrote  Jan 4 2009 at 1:05 AM  
Hi Stephen:
Thank you for the Reading an Excel spreadsheet using ADO.NET sample. I've been meaning to do this for sometime and now you have given me a road map.
Robert Wishlaw

StephenCleary wrote  Sep 22 2009 at 5:17 PM  
Please ask questions on the Discussions page (http://code.msdn.microsoft.com/NitoExcel/Thread/List.aspx); the comments are not monitored.

Triynko wrote  Mar 1 2010 at 6:45 PM  
This is an excellent example with a nice interface. It allows people to see how cryptic values in the connection string and select statement change in response to selecting/toggling explained values in the interface, so this is good for playing around and learning to translate a querying concept into a connection string and select statement.

Updating...
Page view tracker