How to read and write an excel file in java

Question

0.00/5 (No votes)

See more:

Anybody can suggest the number of ways in which i can read and write an excel file using java. Also suggest some libraries for that.

Posted 8-Jan-12 18:17pm

s_akram

Add a Solution

Comments

Abigaill 9-Nov-18 3:24am

Here is another Java library for Excel files that can be used to read and write both older XLS and newer XLSX formats.

Nountylegre 25-Feb-19 8:36am

Yes, this works great, many thanks!
This is how I'm reading Excel file in Java and this is how I'm writing Excel file in Java.

1 solution

Add a Solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2012-01-08T18:29:00

Solution 1

Sure; this is an open-source product Apache POI. Please see:
http://en.wikipedia.org/wiki/Apache_POI[^],
http://poi.apache.org/[^].

—SA

Posted 8-Jan-12 18:29pm

Sergey Alexandrovich Kryukov

Comments

Ankur^\m/ 9-Jan-12 0:51am

That should help, 5!

Sergey Alexandrovich Kryukov 9-Jan-12 0:52am

Hope so; thank you, Ankur.
--SA

s_akram 9-Jan-12 4:20am

Is this only way or any other different ways

Sergey Alexandrovich Kryukov 9-Jan-12 14:48pm

Who can ever say that such thing can be the only way? Certainly not, but this is what I would recommend to look at first. After all, you can develop your own library like that or find something else, but you see, development under Apache has very good reputation in general. The Open Source is another very important factor, not just in terms of money but also in terms of security and quality. At his moment I don't know any apparently competitive products, but it does not guarantee they do not exist or might appear in near future.

Do you have any problem with Apache POI though?
--SA

Monjurul Habib 9-Jan-12 14:33pm

5! and congrats :)

Sergey Alexandrovich Kryukov 9-Jan-12 14:48pm

Thank you very much, Monjurul.
--SA