Pull info from Excel Spreadsheet into C# Web Application

Question

I want to show information from an excel spreadsheet in a web page. The xls will have maybe 5 columns, and as many rows as needed. The columns will be 'Name', 'Created Date', 'Expired Date', 'Owner', and maybe down the road maybe more.

What I would like is for the C# to nightly read the xls, and display the information in a table on the website.

If there is a PDF available for download I am going to link that as well.

Thanks in advance, Gene

Answer 1

Here is an article describing how to read an Excel file using the OLEDB data provider.

However, this probably needs to live in a service or its own executable and kicked off with a scheduled job to fill some tables that your web page looks at.