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!
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!
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!
points increased if anyone can help me
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
or use Apache POI library to manipulate your Excel data, change layout, etc.
or use both of these to get what you want.