Nicholas,
JXL is certainly able to do this. It works with workbooks (excel file) and sheets (tab). Here is a snippet from a web based downloader I wrote that should give you some ideas how to use JXL. As for the UI that can simply implemented through standard swing or through the web.
; wb=Workbook.createWorkbook(response.getOutputStream());
; sh=wb.createSheet("Sheet 1", 0);
; headerCell=new WritableCellFormat(new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD));
; moneyFormat=new WritableCellFormat(new NumberFormat("$###,###,##0.00;($###,###,##0.00)"));
; numberFormat=new WritableCellFormat(new NumberFormat("########0.00;(########0.00)"));
HTH
On Sat, 2008-07-05 at 05:10 +0000, Nicholas wrote:
Hi,
Currently i am working on price file project. My questions are
Is Java able to move the excel spread sheet data to a new worksheet eg
Tab "sheet1" to Tab "price"?
Can java read the the excel spread sheet data and prompt user of the
similar part numbers ? As a similar part number may contain different
pricing.
Upon selected of the price, will it be able to update in to the new
works like Tab "price"?
Please advise thank you
がば{87;てく2384;ӕ3;い！
|
.
easy.com or visit our link below. www.freewe