How to read open office excel sheet in java and display in gridview

Question

0.00/5 (No votes)

See more:

I am very new to java so excuse me if i am asking anything wrong. I need to develop a web application which reads open office excel sheet that is i have 16 columns i need to read the data in all the 16 columns and insert it into database also i should display that data in grid view how can i do this using java.

I could not find the source for this as i am new to this.

What I have tried:

i could not find any source for doing this

Posted 24-Jun-17 7:25am

Member 12324523

Updated 24-Jun-17 9:08am

RickZeeland

v2

Add a Solution

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)

RickZeeland · Answer 1 · 2017-06-24T09:08:00

Solution 1

The OpenOffice API would be a good starting point I think: The Apache OpenOffice API Project[^]
I'm not a Java programmer, so I can not answer questions regarding Java programming, sorry !

Posted 24-Jun-17 9:08am

RickZeeland