1.从excel中读取数据
Workbook book = Workbook.getWorkbook(new File("C:\\RYAJ.xls"));// 获得第一个工作表
Sheet sheet = book.getSheet(0);
int rows = sheet.getRows();
//System.out.println(rows);
for (int i = 1; i < rows; i++) {//对每行进行处理
String id = sheet.getCell(0, i).getContents();
String myCourt = sheet.getCell(1, i).getContents();
}
book.close();
2.将数据写到excel中
WritableWorkbook writeBook = Workbook.createWorkbook(new File("C:\\RYAJ1.xls"));
WritableSheet writeSheet = writeBook.createSheet("第一页", 0);
Label label1 = new Label(0, num, myId);
Label label2 = new Label(1, num, courtName);
Label label3 = new Label(2, num, orgName);
Label label4 = new Label(3, num, myName);
Workbook book = Workbook.getWorkbook(new File("C:\\RYAJ.xls"));// 获得第一个工作表
Sheet sheet = book.getSheet(0);
int rows = sheet.getRows();
//System.out.println(rows);
for (int i = 1; i < rows; i++) {//对每行进行处理
String id = sheet.getCell(0, i).getContents();
String myCourt = sheet.getCell(1, i).getContents();
}
book.close();
2.将数据写到excel中
WritableWorkbook writeBook = Workbook.createWorkbook(new File("C:\\RYAJ1.xls"));
WritableSheet writeSheet = writeBook.createSheet("第一页", 0);
Label label1 = new Label(0, num, myId);
Label label2 = new Label(1, num, courtName);
Label label3 = new Label(2, num, orgName);
Label label4 = new Label(3, num, myName);