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 ?
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/
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+";";
Hi
Please don't hijack other people's threads.
Start you own new thread and someone will help
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.