操作EXCEL

操作EXCEL 可以使用第三方jar包（jxl）

 //第一步指定 excel工作薄位置
   Workbook book = Workbook.getWorkbook(new File("xxx//xxx.xls"));

//第二步指定 EXCEL中的工作表 
  Sheet sheet = book.getSheet("sheet1")；

//第三步  得到行数 
  int rows = sheet.getRows();

//第四步  得到第i行第一列值得内容 
  sheet.getCell(0,i).getContents().trim();

写文件

public class NeilTest {

    public static void main(String[] args) throws IOException, WriteException {

        WritableWorkbook wwb = Workbook.createWorkbook(new File("c:/xx.xls"));
        WritableSheet sheet = wwb.createSheet("www",0);

        Label label = new Label(0,0,"this is lable");   //第1个0表示列 第2个0表示行
        sheet.addCell(label);

        Label label2 = new Label(0,1,"this is lable");
        sheet.addCell(label2);

        Label label3 = new Label(1,1,"this is lable");
        sheet.addCell(label3);



        wwb.write();
        wwb.close();


    }


}

修改文件

 Workbook book = Workbook.getWorkbook(new File("c:/style.xls"));   //style.xls 是模板
        WritableWorkbook wwb = Workbook.createWorkbook(new File("c:/eee.xls"), book);    //eee.xls 是将要生成新的EXCEL

        WritableSheet sheet = wwb.getSheet(0);
        WritableCell writableCell = sheet.getWritableCell(3, 5);   //第3列（从0开始算） 第5行（从0开始算）。实际是第4列第6行
        
        String context = writableCell.getContents();
        System.out.println("555"+context);

        if (writableCell.getType() == CellType.LABEL) {
            Label label = (Label) writableCell;
            label.setString("测试");
        }
        wwb.write();
        wwb.close();
        book.close();