Link to home
Start Free TrialLog in
Avatar of proxylaang
proxylaang

asked on

using Java writing / to write on an excel file (column, row)

Hi!
Using java (jdbc), can I write into an excel file under a column without a name (column name is always on row 1 right?) ?
and also can I add a new column (while java program is running) by writing something (column name ) in row 1, any column and then update the newly "created" column?  or can I indicate specifically on what cell number I could write into?
How do you do it if it's possible?  I can't find it on the net.

Thanks a lot!
Avatar of matthew016
matthew016
Flag of Belgium image

I think that you should import the spreadsheet into Access, MySQL, ... than use JDBC to manipulate the data,
or use Apache POI library to manipulate your Excel data, change layout, etc.
or use both of these to get what you want.
Avatar of proxylaang
proxylaang

ASKER

err I wouldn't like doing it all over again using POI or others besides the simple JDBC in java.  Unless there's a reason.
points increased if anyone can help me
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of matthew016
matthew016
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin