public void writer(){
try
{
Workbook booka= Workbook.getWorkbook(new File("F:ÍøÂçÕ˺żÇ¼±í.xls"));
//»ñµÃµÚÒ»¸ö¹¤×÷±í¶ÔÏó
Sheet sheeta=booka.getSheet(0);
int a = sheeta.getColumns();
int b = sheeta.getRows();
WritableWorkbook book = Workbook.createWorkbook(new File("F:ÍøÂçÕ˺żÇ¼±í¸±±¾.xls"));
WritableSheet sheet = book.createSheet("µÚÒ»Ò³", 0);
for(int c=0;c<b;c++){
for(int i=0;i<a;i++){
Cell cell1=sheeta.getCell(i,c);
String result=cell1.getContents();
Label label = new Label(i, c, result);
sheet.addCell(label);
book.write();
}
}
book.close();
booka.close();
} catch (Exception e) {
System.out.println(e);
}
}
------½â¾ö·½°¸--------------------
°Ñbook.write();·Åµ½Ñ»·ÍâÃæ¡£
- Java code
for(int c=0;c<b;c++){for(int i=0;i<a;i++){Cell cell1=sheeta.getCell(i,c); String result=cell1.getContents(); Label label = new Label(i, c, result);sheet.addCell(label);}}[color=#FF0000]book.write();[/color]book.close();booka.close();