How to import excel data into C# objects using ClosedXML library | Generic Import Method

[@user-eh2pi2vc2c]

I was not able to get this to work as I always receive an error on prop.setValue(obj, Convert.ChangeType(val,type) - The error was Invalid Cast Exception Object must implement IConvertible. Indexes, values and Property types were all found but I could not see the issue on this line. Any ideas on what could be happening?

[@ducna0610]

You can use: prop.SetValue( obj, TypeDescriptor.GetConverter((Type)type) .ConvertFromInvariantString(val.ToString()) );

[@rutujakodlinge9676]

I'm facing same issue.. can someone please suggest the solution..

[@Taimastavern]

@@rutujakodlinge9676 anyone fix this? same

[@ukaszczyz2962]

Same for me

[@CarbonFanatic]

same issue

[@anhtuanpham291]

How to process if value of Cell is enum !

[@roshankj4243]

My excel columns contains spaces between names i need to change my import function? Rest all same?

[@gautammokal]

Thanks for watching the video. Please see if this helps kzbin.info/www/bejne/aHKvZ5lpoLqAo5Y

[@rajubro7445]

Is it open source? I am unable to install in package manager console

[@nishathakur994]

My column names in excel sheet have spaces, how to write properties for that

[@gautammokal]

Mapping excel fields with object properties can help. Here is a video on it kzbin.info/www/bejne/aHKvZ5lpoLqAo5Y Thanks

[@nishathakur994]

@@gautammokal thankyou, does it work for. Xlsx excel file too?

[@TurgayTuerk]

Alternatively you can use the 'DisplayName' attribute for your properties and access them by the 'CustomAttribute' reflection property of PropertyInfo.

[@ghullaq]

Will this work if column names in Excel file do not match the names of fields in your classes?

[@gautammokal]

It will not work. We can add mappings for column names and fields. Thanks for watching this video.

[@gautammokal]

Just uploaded a new video. kzbin.info/www/bejne/aHKvZ5lpoLqAo5Y This shows how to use mappings while importing CSV data. Same logic will help in case of Excel import.

[@ghullaq]

@@gautammokal Awesome! Thanks for taking time and letting me know!

[@anhtuanpham291]

Anyone try with 1.000 rows ?

[@gonzalomoraga2781]

Yes i do. It works fine. But i can´t use the lastest version of ClosedXML.

[@TurgayTuerk]

Thanks for the video. Very usefull!

[@ANECKA99]

Excellent, thanks

[@citizendc9]

Thanks!

[@jayakumar2927]

Github