Ad:

Java Discussion Thread
Unsolved
Views: 29054

Permalink

Dec 3rd, 2007

Export/Import Excel in java

Expand Post »

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

Similar Threads

transferrable equation editor fields from word doc in Visual Basic 4 / 5 / 6

alpakr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2007

Permalink

Dec 3rd, 2007

Re: Export/Import Excel in java

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

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.

paradox814

Reputation Points: 13

Solved Threads: 4

Posting Whiz

Offline

351 posts
since Oct 2004

Permalink

Dec 3rd, 2007

Re: Export/Import Excel in java

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...

alpakr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2007

Permalink

Dec 3rd, 2007

Re: Export/Import Excel in java

Google POI and/or JExcel

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: Assignment on java 2 j2sdk1.4.2_04

Next Thread in Java Forum Timeline: Database connectivity to ms-access

DaniWeb Message

Cancel Changes

User Name
Password