0

Hello everyone ,

I'm trying to update an existing Excel file(.xls) and add some rows in it .
I already can open an xls and display it in a jTable, but i want to add rows to a specific sheet that i choose in a combobox . My xls have multiple sheets .

Can anyone help please ?

5
Contributors
7
Replies
44
Views
3 Years
Discussion Span
Last Post by JamesCherrill
0

Is there a way to copy a sheet from an existing Excel file to another one ?

0

I am trying to update data into the xlsheet but it displays an error please guide me .I write ike this

sring statusupdate="update [sheet1$] set [Result]='pas' where Tcid1+"="+T001+";";

Edited by dhanamma

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.