CODEWITHSUNDEEP
c#asp.netexcel
Gene
Gene

Reputation: 89

Pull info from Excel Spreadsheet into C# Web Application

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

Upvotes: 1

Views: 919

Answers (1)

Jeremy
Jeremy

Reputation: 4848

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.

Upvotes: 1

Related Questions