Export/Import Excel in java

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Java section within the Software Development category of DaniWeb, a massive community of 455,985 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,772 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Java advertiser: Lunarpages Java Web Hosting

Thread Tools Display Modes

Views: 3500 | Replies: 3

•

Join Date: Dec 2007

Posts: 2

Reputation: alpakr is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

alpakr

Offline

Newbie Poster

Export/Import Excel in java

Dec 3rd, 2007

pl. help me in how to export and import MsExcel in java

•

Join Date: Oct 2004

Location: San Francisco, CA

Posts: 338

Reputation: paradox814 is an unknown quantity at this point

Rep Power: 5

Solved Threads: 2

paradox814 paradox814 is offline

Offline

Posting Whiz

Re: Export/Import Excel in java

Dec 3rd, 2007

use a csv extenion on any text file
for example, a file named output.csv
with the following data:

Help with Code Tags

(Toggle Plain Text)

a,b,c
1,2,3
x,y,x

would produce the following in excel,
cell a1: a
cell b1: b
cell c1: c
cell a2: 1
cell b2: 2
cell c3: 3
cell a3: x
cell b3: y
cell c3: z

etc...
every new line is a new row in excel
every comma is a new column in excel

Last edited by paradox814 : Dec 3rd, 2007 at 4:43 am.

•

Join Date: Dec 2007

Posts: 2

Reputation: alpakr is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

alpakr

Offline

Newbie Poster

Re: Export/Import Excel in java

Dec 3rd, 2007

i want to export my data from oracle to excel using java and get some charts from excel as the output back to java as this is my intermediate step in the project i am implementing.
pl help me Thanks...

•

Join Date: Feb 2006

Posts: 1,508

Reputation: masijade is a glorious beacon of light

Rep Power: 10

Solved Threads: 136

masijade

Online

Posting Virtuoso

Re: Export/Import Excel in java

Dec 3rd, 2007

Google POI and/or JExcel

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan