操作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();
页:
[1]