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 ?

Thanks Yeztzederixx , i'll try with that . (y)

Yeztzederixx 's right.use api

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

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+";";

Click Here

My Xlsheet is like below

un pwd Result Tcid
admin manager T001

Hi
Please don't hijack other people's threads.
Start you own new thread and someone will help

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.