package test; // 生成Excel的类 import java.io.File; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class CreateExcel { public static void main(String args[]) { try { // 打开文件 WritableWorkbook book = Workbook.createWorkbook(new File("aa.xls")); // 生成名为“第一页”的工作表,参数0表示这是第一页 WritableSheet sheet = book.createSheet("第一页",0); // 在Label对象的构造子中指名单元格位置是第一列第一行(0,0) // 以及单元格内容为test //Label label = new Label(0,0,"testssss"); for(int i=0;i<10;i++){ for (int j=0;j<10;j++){ Label label = new Label(i,j,i*j+""); sheet.addCell(label); } } // 将定义好的单元格添加到工作表中 // 生成一个保存数字的单元格 必须使用Number的完整包路径,否则有语法歧义 单元格位置是第二列,第一行,值为789.123 jxl.write.Number number = new jxl.write.Number(1, 0, 555.12541); sheet.addCell(number); // 写入数据并关闭文件 book.write(); book.close(); } catch (Exception e) { System.out.println(e); } } } package test; // 读取Excel的类 import java.io.File; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; public class ReadExcel { public static void main(String args[]) { try { Workbook book = Workbook.getWorkbook(new File("test.xls ")); //获得第一个工作表对象 Sheet sheet = book.getSheet(0); //得到第一列第一行的单元格 int rows = sheet.getRows(); int column = sheet.getColumns(); for (int i=0;i<rows;i++){ for (int j=0;j<column;j++){ Cell cell1 = sheet.getCell(j, i); String result = cell1.getContents(); System.out.print(result+","); } System.out.println("-----------------------------"); } book.close(); } catch (Exception e) { System.out.println(e); } } } package test; import java.io.File; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class UpdateExcel { public static void main(String args[]) { try { //Excel获得文件 Workbook wb = Workbook.getWorkbook(new File("test.xls")); //打开一个文件的副本,并且指定数据写回到原文件 WritableWorkbook book = Workbook.createWorkbook(new File("test.xls"), wb); //添加一个工作表 WritableSheet sheet = book.createSheet("第二页 ", 1); sheet.addCell(new Label(0, 0, "第二页的测试数据 ")); book.write(); book.close(); } catch (Exception e) { System.out.println(e); } } }