Reading data from Excel sheet using entity framework

asp.net asp.net-mvc asp.net-mvc-5 c# entity-framework

Question

We have some info that is contained within an excel sheet. the excel sheet contains two columns; customer name + customer balance. Now I need to display this info inside my asp.net mvc view, basically to query the excel sheet based on the customer name and display its total balance inside my view.

In this way we will be uploading the excel sheet inside our system each month or each day , and we will be querying the excel sheet instead of the DB. So is this possible using EF ? or it is better to exact the data from the excel sheet and add it to Datable inside the database? Thanks

1
3
1/5/2015 11:27:25 AM

Popular Answer

You can use LinqToExcel , this provides normal linq structure to query excel sheets

5
1/5/2015 11:34:24 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow