java中workbook_java使用Workbook进行excel读取和创建

public static void main(String[] args) throws Exception {

//输入流。a.xls为要读取的excel文件名,不可为xlsx后缀

Workbook book = Workbook.getWorkbook(new File("E:\\a.xls"));

//获得第一个工作表对象(ecxel中sheet的编号从0开始,0,1,2,3,....)

Sheet sheet = book.getSheet(0);

//输出流

WritableWorkbook wwb = Workbook.createWorkbook(new FileOutputStream("E:\\b.xls"));

//创建第一个工作表对象,名为("Sheet 1)

WritableSheet ws = wwb.createSheet("Sheet 1", 0);

//单元格对象

Label label;

//label里面的样式

WritableFont wfc = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);

WritableCellFormat wcfFC = new WritableCellFormat(wfc);

//前三行数据,列不用加条件

for (int i = 0; i < 13; i++) {

label = new Label(i, 0, sheet.getCell(i, 0).getContents(), wcfFC);

ws.addCell(label);

label = new Label(i, 1, sheet.getCell(i, 1).getContents());

ws.addCell(label);

label = new Label(i, 2, sheet.getCell(i, 2).getContents());

ws.addCell(label);

}

int i = 3;

//共821行数据

while (i < 821) {

//共10列数据

for (int j = 0; j < 10; j++) {

//此处可以根据列的不同加条件

label = new Label(j, i, sheet.getCell(j, i).getContents());

ws.addCell(label);

}

i++;

}

book.close();

wwb.write();

wwb.close();

System.out.println("结束");

}

*当控制台不输出"结束"时,代表上面代码出错卡住了,可以调试看下

*此代码由于时间原因不是很完善,但可做参考