I cannot thank you enough for this video. Your content has been an absolute lifesaver for me. Your dedication to providing high-quality and informative content is truly remarkable. You've not only helped me complete my task, but you've also expanded my knowledge and skillset. Your ability to explain complex topics in a simple and engaging manner is a gift, and it's evident that you genuinely care about your viewers' progress. I've been inspired by your work, and it has encouraged me to explore new areas and improve my skills. I look forward to more of your content and eagerly await the knowledge and inspiration you'll continue to share with us. Your efforts have made a significant impact on my life, and I'm immensely grateful for that. Thank you once again for your exceptional work. You're a shining example of how a passionate content creator can positively affect the lives of others. Your contributions to the RUclips community are invaluable, and I feel lucky to have found your channel.
Hi, and thanks for the demo. I would like to know how I could validate and prevent the upload if my .xlsx spreadsheet didn't have any data. Currently, when I try to import an empty spreadsheet, I get this error: "Object reference not set to an instance of an object." I would like to return an exception if my file is empty.
it is your approach that make simple, clear and done . Thank you. after return list, How I used it for display on the view and save to the database. I am beginner.
I have folowed your code but i am getting the error IndexOutOfRangeException: Worksheet position out of range. "ExcelWorksheet worksheet = package.Workbook.Worksheets[0]" ,,, do you have any sugession to solve it please?
Thank you that help! how I can insert , update, and delete operation of data from "spreadsheet embed UI viewer" to the data base table. difficult part for me is connection string on the startup, appsettings, controller page, header mapping for now is not difficult for insert, update and delete for sample at you tube.
Hi, thanks for the video. I have a problem when one cell is empty in the Excel. "Object reference not set to an instance of an object.". Exactly using your code, without any change. Help please
I cannot thank you enough for this video. Your content has been an absolute lifesaver for me. Your dedication to providing high-quality and informative content is truly remarkable. You've not only helped me complete my task, but you've also expanded my knowledge and skillset.
Your ability to explain complex topics in a simple and engaging manner is a gift, and it's evident that you genuinely care about your viewers' progress. I've been inspired by your work, and it has encouraged me to explore new areas and improve my skills.
I look forward to more of your content and eagerly await the knowledge and inspiration you'll continue to share with us. Your efforts have made a significant impact on my life, and I'm immensely grateful for that.
Thank you once again for your exceptional work. You're a shining example of how a passionate content creator can positively affect the lives of others. Your contributions to the RUclips community are invaluable, and I feel lucky to have found your channel.
Great work my guy. You just saved me a lot of time. Please keep it up!
Thank you very much! This was very helpful!
Thank you so much for this simple but useful video. Keep up the good work.
Thank you so much it's really very helpful for us
Thank you so much sir ,ur code helped me alot thank you do much
Thanks mate, clear explanation
Hi, and thanks for the demo. I would like to know how I could validate and prevent the upload if my .xlsx spreadsheet didn't have any data. Currently, when I try to import an empty spreadsheet, I get this error: "Object reference not set to an instance of an object." I would like to return an exception if my file is empty.
Count the uploaded excel sheet row before insert into database.
I'm still waiting for connection to DB, its just read file excel right ?
Yes
we can use table right instead of list that will make it faster
Thanks, That was very useful
Not getting Dimensions Property inside worksheet. Can you assist?
it is your approach that make simple, clear and done . Thank you. after return list, How I used it for display on the view and save to the database. I am beginner.
I am getting this error... in HomeConrtoller line 26 "System.NullReferenceException: "Object reference not set to an instance of an object.""
What is the line on 26 number?
hi bro can i import Excel file using web api c#
great!!!! congratulation!
Hi, What about integers or booleans with that format? you have used only string. Thanks
Add condition for integer and booleans and change into string they display in excel
Great. But if my excel file keep changes along with columns to different tables, how to do that?
Hello how to print returned list ? :)
Great Help. Could upload the XL file with ease using your technique. Is there a way we can contact you?
yes you can contact on may email: dotnetguru93@gmail.com
@@CsharpSpace Thanks please check your mail.
thank you for all
sir, what if i want to use colCount as well instead of column number 1, 2, 3.... and use two for loops?? and how can i perform that ??
sir why i am getting error while doing list.add(new modelname { field.... } it says identifier expected
Try to debug code with break point and find the exact error
I have folowed your code but i am getting the error IndexOutOfRangeException: Worksheet position out of range. "ExcelWorksheet worksheet = package.Workbook.Worksheets[0]" ,,, do you have any sugession to solve it please?
Change package.Workbook.Worksheets[0] for package.Workbook.Worksheets[1]
@@ronaldmirabal5400 it didnt work ! , do you ave another wait o solve this
Hi, I'm unable to import the excel contents to the Import method. Can you please help? Thank you so much!
Thank you that help!
how I can insert , update, and delete operation of data from "spreadsheet embed UI viewer" to the data base table. difficult part for me is connection string on the startup, appsettings, controller page, header mapping for now is not difficult for insert, update and delete for sample at you tube.
Hi, thanks for the video. I have a problem when one cell is empty in the Excel. "Object reference not set to an instance of an object.". Exactly using your code, without any change. Help please
give them default value as string.Empty example ;
user = (worksheet.Cells[row, 1].Value ?? string.Empty).ToString().Trim()
Hi, It was so helpful thanks a lot. Now, How can I save it in the database?
Hey, I liked the video.. I had a small query.. I have multiple sheets in one excel.. So how do I import one particular sheet only?
Try to define sheet no in your code,
Hey , I have to do same task.....so how can I insert multiple sheet data in database
Hi thank you so much, this video help me a lot. But anyway, how if my field value is enum, how can I import it?
hello, how can ı pass null the rows ?
Thank you for this
please how can i view the data in the index before uploading it to the database in a table
Bind the converted list into index view before send to database
No read excel file... file==null
It would be great if u provide the code for this.
System.NullReferenceException: "Object reference not set to an instance of an object."
Nice tutorial. how to return a view instead of having return list?
Licence file exception
How do I connect import to a Sql Server database?