Upload Excel file and extract data - asp.net mvc 3

c# asp.net-mvc excel excel-2007
chobo2 picture chobo2 · Feb 21, 2011 · Viewed 20.8k times · Source

I am wondering how do I extract data out of a 2007 excel file? I am using asp.net mvc 3. My plan is to have a upload section that you choose a file and hit upload. I have no clue after that what kind of format it will be or what I need to do to extract the values out.

Thanks

Answer

Matt picture Matt · Feb 22, 2011

Once you have the spreadsheet uploaded and you save it to a file on the web server it is quite easy to use LINQ to select the rows from the spreadsheet. Check this out for more info.

http://code.google.com/p/linqtoexcel/

Related questions

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine (server)

I know that is this question has dozen of answers and posts, but nothing works for me. I have my MVC 5 application and I deploy it to the IIS 7.5 to my server. Application runs great, everything is works until I …

Read More
Generating an excel file with EPPlus is failing

When I try to generate an Excel file using EPPlus, Excel give me the following error message: Excel cannot open the file 'myfilename.xlsx' because the file format or file extension is not valid. Verify the the file has not …

Read More
Get all the values from excel file by using linqtoexcel

I'm using linqtoexcel in my asp.net mvc 4 project to read an excel file & get all the values from there. But I'm only getting the values of last row. Here are my codes, Controller public ActionResult ExcelRead() { string pathToExcelFile = "" + @"…

Read More