Generating CSV file from object in java

Question

At this moment I am working on generating csv from object and I got stuck. I dont know how to generate csv for nested class. For example we have got following classes:

@Getter
@Setter
public class Person {
  private int age;
  private Name name;
}

@Getter
@Setter
public class Name {
  private String firstName;
  private String lastName;
}

There is huge problem for. Actually I tested few libraries like jackson and commons csv and I did not find solution. The main problem is that I dont know what fields are in object and have to prepare headers dynamically. Is there any simple way or library which allows for that operation? I would be thankfull for any tips.

Is there any particular reason you want to use CSV over e.g. JSON? — Coderino Javarino
– Coderino Javarino, Commented Jul 11, 2016 at 16:06

Community · Accepted Answer · 2017-05-23 12:19:14Z

1

You might have got the answer if googled it. It already has answer here : Object to CSV

Using super csv : Using super csv to write in csv from object

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Jul 11, 2016 at 16:14

Nakul Kumar

1702 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jo Dung Over a year ago

Actually it is not working with nested class, only for pojos

Nakul Kumar Over a year ago

Csvs don't work for nested classes. They can be represented in excel format too. Nested classes can't be represented in that format. You have to go with plain pojos.

AJ Jwair · Accepted Answer · 2016-07-11 16:19:52Z

0

What is the purpose of creating the csv file? Is it necessary for you to preserve the nesting of classes? Are you re-constructing the objects from the csv files?

If you're only interested in the data of your objects, consider reducing everything down to the primitive types (or whatever class you have a meaningful toString() for), aka flattening your hierarchy. age, name ==> age, firstName, lastName

You can use reflection to dynamically get the hierarchy.

Does the output have to be a csv? Did you consider using a different format that preserves hierarchy like JSON or XML?

answered Jul 11, 2016 at 16:19

AJ Jwair

451 silver badge5 bronze badges

Collectives™ on Stack Overflow

Generating CSV file from object in java

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related