Write Data to Excel

[Kedarnath Bhagwat]

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]

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]

Vice-versa is quite possible..

[Kedarnath Bhagwat]

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 .