0

I need to output data to a CSV file from Java, but in that csv file I hope to create multiple sheets so that data can be organized in a better way. After some googling, it seems this is not possible. A CSV file can only receive one-sheet data.

Is this true? If yes, what would be the options? Thank you.

Improve this question
1
  • Is it an option to add an extra column to your csv file that identifies what group that data belongs to? Commented Jun 15, 2015 at 22:53

2 Answers 2

Reset to default
3

CSV file is interpreted a sequence of characters which comply to some standardization, therefor it cannot contains more than one sheet. You can output your data in a Excel file that contains more than one sheet using the Apache POI api.

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

2 Comments

Probably I have to use this. Thanks.
@martin It's the most popular java api to deal with MS Document, easy and reliable.
-2

Comma Separated Value lists are generally created in plain text files, which do not have multiple pages. What you could do instead is create multiple CSV files, but if you really have a lot of data, a data base might be your best bet.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.