Get data from an Excel(can have more than one sheet) to parse it to a business class object

[Testname]

Get data from an Excel(can have more than one sheet) to parse it to a business class object

[Testname]

If I already know the type of my business class object, some kind of casting between an excel(can have more than 1 shet) to a businessclass object. How to do this ?

[Testname]

Each excel sheet represents a  single business class object

[Abirami Varadharajan]

Hi Testname, 

  

Thank you for contacting Syncfusion support. 

  

We have prepared sample as per your requirement and the sample can be downloaded from following location. 

  

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/BusinessObject1582280198.zip   

Please let us know if you have any concerns. 

  

Regards, 

Abirami. 

[Testname]

Now I need a method which will automatically cast "row.Cells[...]" to the right .net type instead of explicity cast it like "Convert.ToInt32(row.Cells[...].Number);"

[Abirami Varadharajan]

Hi, 

 

We don’t have any implicit method to cast Excel data automatically. So, we request you to cast it explicitly with appropriate .NET type. 

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami.