Hi,

Im using JXl api to copy some data from one sheet to other..

I have data in source sheet as "1000000000" [without quotes] but when it is getting copied to other it is converted automatically as " 1 E9"

cell.setCellType(cell.CELL_TYPE_NUMERIC);

I used the above code for setting the cell type in template..

Reply...
Thanks in advance