Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Write Data to Excel

 
Kedarnath Bhagwat
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can somebody help me with a code to write to multiple columns of Excel .
I am not using any API and don't want to use any .

I conneceted using DSN .
I am able to succesfully retrieve data but when I write I can write to only one column.
If I write insert into statement with multiple values I get error.
I use executeUpdate to write data

Can somebody help ?
Please let me know if you need more information.
 
Vivek Singh
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you want to export the excel data to a database??

This is very possible i had similar case where i had to export the excel data which had X,Y columns and rows. But i needed some specific Cells.
 
Vivek Singh
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vice-versa is quite possible..
 
Kedarnath Bhagwat
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using Excel as output file or you can say as a database .

I fetched data from Excel using DSN , processed it, and now I want to write output to same Excel in another sheet .

I use executeUpdate to post the data through insert statement .

But the error is related to not matching destination columns with no of columns I have .

I tried adding columns to Excel so that both will match , but it didn't work.

Please send me any example if you have .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic