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

Recommended Answers

All 3 Replies

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

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

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

Google POI and/or JExcel

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.