Java

Java RSS

Export/Import Excel in java

•

Join Date: Dec 2007

Posts: 2

Reputation: alpakr is an unknown quantity at this point

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

Posts: 348

Reputation: paradox814 is an unknown quantity at this point

Solved Threads: 4

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 
 Java Syntax (Toggle Plain Text) 
a,b,c
1,2,3
x,y,x
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

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: 2,359

Reputation: masijade has much to be proud of

Solved Threads: 252

masijade

Online

Nearly a Posting Maven

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