Reading data from Excel sheet using 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

Have a look into using Office Open XML en.wikipedia.org/wiki/Office_Open_XML — BLoB
– BLoB, Commented Jan 5, 2015 at 11:35

General Grievance · Accepted Answer · 2023-06-26 19:54:53Z

6

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

Note: As of January 2022, this project is no longer maintained, as noted in the repo's readme.

edited Jun 26, 2023 at 19:54

General Grievance

5,12039 gold badges40 silver badges60 bronze badges

answered Jan 5, 2015 at 11:34

Aram Tchekrekjian

93511 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vamshi Chilukuri · Accepted Answer · 2015-08-25 07:25:24Z

0

It is better to extract the data from the excel sheet and add it to Datable which you can do using oledbconnection object , connectionobject.GetOleDbSchemaTable.

answered Aug 25, 2015 at 7:25

Vamshi Chilukuri

171 silver badge6 bronze badges

Comments

Graham · Accepted Answer · 2018-10-11 12:01:53Z

0

FileContextCore seems like an effort to make excel and other file types work in EF Core. Obviously this can be nice for consistency if you're already using EF Core.

answered Oct 11, 2018 at 12:01

Graham

1,78818 silver badges24 bronze badges

1 Comment

David Bouška Over a year ago

currently doesn't work for .net 5 and up

Mahesh Malpani · Accepted Answer · 2015-01-05 11:47:16Z

-1

Excel is not a database system so don't think directly you can use the entity framework. But yes Excel can be read using .net APIs

answered Jan 5, 2015 at 11:47

Mahesh Malpani

2,04220 silver badges27 bronze badges

Collectives™ on Stack Overflow

Reading data from Excel sheet using entity framework

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related