Reading Excel data and showing in table format in MVC view

Question

I am using MVC3. I want to read data from Excel sheet which will be saved inside one folder of my application. Row by row I have to validate the data. Finally have to show the same in tabular form on view. If there are validation problems then those cells should have background color red.

So, I am want solution to read data from Excel and showing in tabular form on view as told. What features I can use for this in my MVC application.

Answer 1

I would recommend using Open XML SDK or EPPLUS to do this. If you are using old excel .xls I would recommend using OLE DB