Reading an Excel spreadsheet using ADO.NET

Home

Downloads

Discussions

People

License

RSS

All Resource Updates

Discussions

Releases

Wiki

RSS Feed

RSS

Comments \| Print \| Page Info \| Change History (all pages)	Search Wiki:
Home
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
Last edited Dec 31 2008 at 11:29 PM by StephenCleary, version 4
Comments rwishlaw wrote Jan 4 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 MarkGittoes wrote Jan 15 at 1:10 AM This looks useful and will get me started. I need to read a .xls which is in XML Spreadsheet Format (Xmlss) but ADO.NET can't handle this format. It is easy enough to first save the spreadsheet to regular Microsoft Office Excel Workbook (.xls) and then read it using ADO.NET but my customer will struggle with the .xls extension sometimes working and sometimes not working. Does anyone know if ADO.NET will read XML Spreadsheet Format (Xmlss)? Of course I could transform it using a bit of xslt but I just spent a few days transforming this data to get the spreadsheet!!! Thanks again. tabrezshaikh wrote Feb 27 at 2:15 AM Does this utility allow you to extract comments from an excel file? What would be the format? Sign in to add a comment

Updating...