Import Excel Data to ASP.NET MVC

[@MaiLe-ct5rw]

why i have to end task excel to open excel file in the second time. Can u have better idea?

[@mihaiflorianenache4110]

I can not use HttpPostedFileBase class. Why ?

[@anslemopelcastre5980]

For net core, have you a project? .

[@gleenababy1731]

Which reference contains the namespace ImportExcelFileInASPNETMVC? I'm facing the error (Please tell me how to get rid of it):-
Severity Code Description Project File Line Suppression State Error CS0246 The type or namespace name 'ImportExcelFileInASPNETMVC' could not be found (are you missing a using directive or an assembly reference?) WebApplication1 C:\Users\New\Desktop\Kath\WebApplication1\WebApplication1\Controllers\ProductController.cs 8 Active

[@cihanbozkurt30]

This structure does not work on the server side. I do not have problems in local. But the server does not add. Could you help ?

[@quockyla8415]

i have a problem, but with property of database Type is Date or Datetime, how to convert, i try Convert.ToDateTime() and DateTime.Parse() but i not work. pls rep me

[@gauravnautiyal2925]

why u have taken i=3 in for loop

[@khoalam8017]

can you helpl me: how open recent in reference manager visual studio 2015

[@gennadiigomeniuk5002]

Can you tell me why the value of row in the "for" loop should be 3? It seems like value of 3 works no matter where the table is placed in the sheet.

[@frknbltci]

heyy, While Coide in line 33, we are taking Process Error. How to fix this issue ?

[@hienpham6974]

I go through all your video and at the end when i import an Excel file the program breaks at System.IO.File.Delete(path); . Can you solve this problem?

[@haifao8569]

I faced the same problem.. open the task manager you will see the excel file in processes chose it and click on end task, I think we should close it from the program

[@DeepakMalik-pd4ok]

Even I am also facing the same issue. Please use workbook.close and application.quit.

[@victorjara7438]

@@DeepakMalik-pd4ok great, its work, thx =)

[@HagenMobiler]

I suggest you to use those lines in your code:
string fileName = Path.GetFileName(excelfile.FileName);
string path = Path.Combine(Server.MapPath("~/Content"), fileName);
Just after the line
if (fileExcel.FileName.EndsWith("xls") || fileExcel.FileName.EndsWith("xlsx")) { (line 28 on your code)
My suggestion (1st line) gets the real file name, just e.g SpreadSheet.xlxs, not the complete path from client side and then it combines to upload files folder Path in server.
Thanks for you code, was very helpfull

[@LearningProgramming]

+HagenMobiler Thanks for your suggestion

[@tainguyen7495]

If data type datetime. how to import into table in database ? tks

[@hajamainudeen5396]

Does it works in visual studio 2019?

[@LearningProgramming]

Yes, You can use with VS 2019

[@hajamainudeen5396]

Okay, I got an error as Hresult efail has been returned from a call to a COM component, can u help me?

[@hajamainudeen5396]

When adding the reference I got the above error

[@AnuRadha-wb7ev]

Can u please tell. Me the code to directly fetch the data from excel file without uploading it

[@ozgureren8925]

great leessonn

[@RafayKhanfy]

Getting error at workbook.ActiveSheet.
cannot implicitly convert type 'object' to 'microsoft.office.interop.excel.worksheet'.

[@hungerfreenation1691]

I get directory error while using Combine function.. because there is no Server.MapPath in .net core

[@LearningProgramming]

You can use IWebHostEnvironment to find images in wwwroot

[@alejandroelizondogonzalez9802]

Hello, if I bought this code from you, could I get it today?

[@LearningProgramming]

Please pay for me as video description. I will share code demo to you.

[@alejandroelizondogonzalez9802]

@@LearningProgramming Ok, money sent!

[@mohammadaqeel2841]

Thaaaaaaaaaaaaaaaaaaaaaaaaaaaank you Sooooooooooooooooo Much.. You've made my Day..

[@memansoorimtiaz]

Sir how to insert excel sheet in sql using entity framwork database first?

[@Gregopaok4]

i got problem in statement - foreach(var p in ViewBar.ListProduct) ListProduct is not recognized how to solve it?

[@michaelchandra9100]

Perhaps because ListProduct is a variable which given from Controller for throwing it to View. You need to define the ListProduct first so it shouldnt be empty.

[@vikasgowda351]

Can I get a code to delete a column present in excel sheet using asp. Net. I will pay you money for the working code

[@atiqahazizee1592]

it shows no error, but i can't display my data from the excel worksheet

[@AlemaxM]

I open the file and read it, but the problem is when i see the task manager there is excel process like your video when you close two process , who i can close it?, I think that you are not closing the excel file , but I don't have idea how to close it. Can you understand me?. Nice video :). Greetings

[@Nechytailo]

var myFile = System.IO.File.Create(path);
myFile.Close();

[@zhoodarkasymov1774]

stackoverflow.com/questions/17777545/closing-excel-application-process-in-c-sharp-after-data-access - here answer on your question

[@ThunderwavePL]

Need I Office program on my computer?

[@LearningProgramming]

You don't need install Office on your computer

[@faruksengul5813]

I could not refer to Excel.
I downloaded nuget.But did not work. Error =" The COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' could not be assigned to the interface 'Microsoft.Office.Interop.Excel._Application'. '{000208D5-0000-0000-C000-000000000046}' This operation failed because the QueryInterface call in the COM component for the interface with the IID failed with the following error: The library has not been registered. (HRESULT returned exception: 0x8002801D (TYPE_E_LIBNOTREGISTERED))." Can you help plaese ?

[@jeffersonalexandermosetonq4553]

i have the same error, did you fixed ?

[@Khahory]

www.nuget.org/packages/Microsoft.Office.Interop.Excel/

[@nestormatias217]

works it local but in server error
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

[@sunmbalsiddiqui9717]

It is because Microsoft Excel is not installed on your server may be. Installing Microsoft Excel was helpful for me.

[@vinayakjambhale5985]

Hello sir, Thanks for this code, but i got an error on line - Excel.Application application = new Excel.Application();
Error description - Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
I have already done with giving permissions to IUSR IISUSER & all stuff.

[@diogofagundes5622]

Thank you, Saved me.

[@LearningProgramming]

You're Welcome

[@fernandorochaolivera2404]

Hi, if i bought you the code it will come with the excel close file ?

[@LearningProgramming]

Hello, I will share source code demo as video to you.

[@AlemaxM]

How I can close the file??, You can see in the video always is open

[@LearningProgramming]

+Alemaxxx Please explain more detail.

[@jclp5]

+Alemaxxx Use workbook.Close(); before return View("Success");

[@AlemaxM]

+José Carlos Lozano I was trying but that does not work

[@jclp5]

+Alemaxxx
if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
string fileName = Path.GetFileName(excelfile.FileName);
string path = Path.Combine(Server.MapPath("~/Content"), fileName);
if (System.IO.File.Exists(path))
System.IO.File.Delete(path);
excelfile.SaveAs(path);
//Read data from excel file
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List listProducts = new List();
for (int row = 3; row

[@AlemaxM]

That does not work

[@freesyriancam]

I want to buy this project files

[@LearningProgramming]

+Abu Muhamad Please pay 5USD to my paypal account is [e-mail], I will share code demo to you

[@freesyriancam]

+Learning Programming I did, but from another account.
waiting your mail,
Thanks

[@LearningProgramming]

+Abu Muhamad I shared code demo to you. Please check your gmail. Thanks

[@parisasaeedi8674]

Thank you sooooooo much

[@LearningProgramming]

You're Welcome

[@MDMizanurRahman89]

thank you coooooool!

[@LearningProgramming]

Your're Welcome

[@aaronaaronaaron5922]

Grat, tuto :)