asp.net-mvc-3import-from-excel

Reading Excel data and showing in table format in MVC view

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.

Solution

  • 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