ASP.NET version of "Excel as a Data Source"

This sample shows you how to use an Excel (.XLS) file as a data source for an ASP.NET web page. While you need to be careful when using Excel with multiple users, there are times when using Excel as a data source can actually come in quite handy.

If you'd like more info about using Excel with ASP.NET, here are some articles from Microsoft's Knowledge Base. The first two deal with actual Excel files. The third is for displaying data from other sources in an Excel friendly format (similar to our Excel as a Client-Side Data Viewer sample in classic ASP or ASP.NET).

• How To: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET
• How To: Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
• How To: Use ASP.NET to Query and Display Database Data in Excel by Using Visual Basic .NET

Here's a zip file of the code and the associated .XLS file (2.8 KB).

Play with the running version.

View the live source code.

Back to the "Excel as a Data Source" sample