How to convert excel into c# object where c# object contain other complex type properties.

Question

0.00/5 (No votes)

See more:

FirstName	LastName	city	Dist
George	Desh	Pune	Pune

This is my sample Excel file content.
I want to convert this excel file into following c# Object:

C#

public  class Name
{
 public string FirstName{get;set;}
 public string LastName{get;set;}
}
public  class Address
{
 public string city{get;set;}
 public string Dist{get;set;}
}
public class Employee
{
 public Name empName{get;set;}
 public Address empAddress{get;set;}
}

So how can I convert my Excel file into Employee object?

Posted 31-Aug-15 1:28am

Member 10797183

Add a Solution

Comments

Mehdi Gholam 31-Aug-15 8:04am

Which part reading form excel or setting properties on the object?

Member 10797183 1-Sep-15 0:17am

@Mehdi I want to fetch that excel data and fill into c# object of Employee class.

Which will look like :

var objEmp=new Employee()
{
empName = new Name(){ FirstName="George",LastName="Desh"},
empAddress = new Address(){ city="Pune", Dist="Pune"}
}

Sinisa Hajnal 1-Sep-15 6:23am

Which part is the problem? Reading the excel file? Or you already know how to do that, but not how to "convert" the data? What have you tried? What code have you already written?

sreeyush sudhakaran 2-Sep-15 5:06am

refer : https://exceldatareader.codeplex.com/

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)