read:
try{
Workbook workbook = Workbook.getWorkbook(new File(path));
Sheet sheet = workbook.getSheet(0);
int rows=sheet.getRows();
//System.out.println(rows);
int col=sheet.getColumns();
//System.out.println(col);
for(int i=1;i<rows;i++)
{
for(int j=0;j<col;j++)
{
System.out.println(sheet.getCell(j,i).getContents());
//can create your own model data from excel
}
}
workbook.close();
}catch(Exception e)
{
e.printStackTrace();
}
---------------------------------------------------------------------
write excel :
try {
WritableWorkbook book = Workbook.createWorkbook(new File(path));
WritableSheet sheet = book.createSheet( "新生信息统计" ,0 );
//can write data from model list
//write string
Label label0 = new Label( 0 , 0 , "学生编号" );
sheet.addCell(label0);
//write number
jxl.write.Number number = new jxl.write.Number( 0 , 1 , 1);
sheet.addCell(number);
book.write();
book.close();
} catch (Exception e) {
System.out.println(e);
}
posted @ 2009-09-09 10:53 谁是菜鸟? 阅读(120) 评论(0)
编辑