How to interact with Excel files using C# ASP.NET

Question

I hope someone can point me in the right direction. I'm planning to build a web application using Webforms in ASP.NET. In the application, I'll be interacting with Excel files stored in a shared folder to compute the desired output and show the output in the front end. So far, I can accomplish the desired output using the VLOOKUP functions manually, but I have no idea on how to accomplish the same thing using C#.

Am I looking at this in the wrong perspective, if so, are there any better ways to accomplish the same result?

Why are you planning an application in Web Forms? It's a dying technology, and is extremely difficult to build a solid application on top of it. Why not ASP.NET MVC or ASP.NET MVC Core? — mason
– mason, Commented Aug 24, 2018 at 16:41

Joshua VdM · Accepted Answer · 2018-08-24 14:55:20Z

5

This can be done using OleDB, an API made by Microsoft to access data from various datasources. This method saves you the pain of manually accessing an Excel file and parsing the data. Using the OleDb connection will also give you metadata information about the excel file, its tables and columns etc.

There are plenty of tutorials on this out there, here's one of them: OleDb Excel Tutorial. This will teach you everything you need to achieve your goal.

The basic steps to get data through an OleDbConnection are:

Create an OleDbConnection using a connectionstring
Open the connection
Execute a query on the connection
Access the result from a DataTable object

Connectionstrings.com shows you how to form connection strings for many different datasources, including Excel through OleDb.

You need to download and install the OleDb Access driver from Microsoft, which you can get at their website https://www.microsoft.com/en-us/download/details.aspx?id=54920 (it's called "Access driver", but it enables data access for most Microsoft Office system files)

answered Aug 24, 2018 at 14:55

Joshua VdM

6781 gold badge6 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tony Batista Over a year ago

Great! Thank you.

billybob Over a year ago

@TonyBatista: Don't forget to mark the question as answered.

Collectives™ on Stack Overflow

How to interact with Excel files using C# ASP.NET

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related