Excel-- how to copy a cell from one sheet to another in the same file

hi

in an excel sheet how to copy a cell from one sheet to another.

i can create the excel sheet even detect the cell location. but i am not able to copy from one one sheet to another sheet.

the code i used -

String WorkFileName = filename;

Workbook workbook = Workbook.getWorkbook(new File (WorkFileName));

Sheet sheet0 = workbook.getSheet(0) ;

so the sheet0 is created but i cannot copy any cell from sheet0 to another sheet. (like sheet1, sheet2, sheet3...)

while writing the below code i get ClassCastException ..

WritableWorkbook wb = Workbook.getWorkbook(new File(WorkFileName));

please provide the sample code ..

thanks in advance.

[716 byte] By [ukbasaka] at [2007-11-27 11:48:06]