Open & Update an Excel file with Java

[Layki]

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 ?

[Yetzederixx]

JExcel supports up to Excel 2003 (check this)
API: http://jexcelapi.sourceforge.net/
Tutorial for API: http://www.andykhan.com/jexcelapi/tutorial.html

Apache POI supports all Office up to 2008 from what I found.
API: http://poi.apache.org/

[Layki]

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

[q812717031]

Yeztzederixx 's right.use api

[Layki]

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

[dhanamma]

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

[dhanamma]

Click Here

My Xlsheet is like below

un pwd Result Tcid
admin manager T001

[JamesCherrill]

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