需求：利用java读写Excel文件
利用jexcelapi实现Java读写excel文件的功能
首先下载并安装jexcelapi
JExcelApi v2.6.12 (1911kbytes)
解压后把jxl.jar文件添加到Java Build Path中
准备测试excel文件（D:\test\职员.xls）
Java读取excel文件
packagecom.test.IF.service;importjava.io.File;importjava.io.IOException;importjxl.Cell;importjxl.Sheet;importjxl.Workbook;importjxl.read.biff.BiffException;publicclassHandleExcelFile {PRivateString excelFilePath = "D:\\test\\职员.xls";privateString[][] nReadArray;privateintnRows, nColumns = 0;
Workbook xWorkbook;//把Excel中的内容转换成二维数组后返回publicString[][] readExcel() {try{
xWorkbook= Workbook.getWorkbook(newFile(excelFilePath));
Sheet sheet= xWorkbook.getSheet(0);
nRows=sheet.getRows();
nColumns=sheet.getColumns();
nReadArray=newString[nRows][nColumns];for(inti = 1; i < nRows; i++) {for(intj = 0; j < nColumns; j++) {
Cell cell= sheet.getCell(j, i);//(列, 行)String content =cell.getContents();
nReadArray[i][j]=content;
}
}
}catch(BiffException e) {
e.printStackTrace();
}catch(IOException e) {
e.printStackTrace();
}
xWorkbook.close();returnnReadArray;
}publicstaticvoidmain(String[] args) {
HandleExcelFile he=newHandleExcelFile();
String[][] xLine=he.readExcel();for(inti = 1; i < xLine.length; i++) {for(intj = 0; j < xLine[i].length; j++) {
System.out.print(xLine[i][j]+ "|");
}
System.out.println();
}
}
}
测试读取程序，结果为
Java写入excel文件
packagecom.test.IF.service;importjava.io.File;importjava.io.IOException;importjxl.Cell;importjxl.Sheet;importjxl.Workbook;importjxl.read.biff.BiffException;importjxl.write.Label;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;importjxl.write.WriteException;importjxl.write.biff.RowsExceededException;publicclassHandleExcelFile {//生成ExcelpublicvoidwriteExcel() {try{//生成可写入的WorkbookWritableWorkbook xWritableWorkbook = Workbook.createWorkbook(newFile("D:\\test\\导出测试.xls"));//生成WorksheetWritableSheet xSheet = WritableWorkbook.createSheet("测试sheet", 0);//往Cell设置数据Label label00 =newLabel(0, 0, "A");//0 列 0行Label label01 =newLabel(0, 1, "B");//0 列 1行Label label02 =newLabel(0, 2, "C");//0 列 2行Label label10 =newLabel(1, 0, "D");//1 列 0行Label label11 =newLabel(1, 1, "E");//1 列 1行Label label12 =newLabel(1, 2, "F");//1 列 2行xSheet.addCell(label00);
xSheet.addCell(label01);
xSheet.addCell(label02);
xSheet.addCell(label10);
xSheet.addCell(label11);
xSheet.addCell(label12);//写入到WorkbookxWritableWorkbook.write();//关闭WorkbookxWritableWorkbook.close();
}catch(IOException e) {
e.printStackTrace();
}catch(RowsExceededException e) {
e.printStackTrace();
}catch(WriteException e) {
e.printStackTrace();
}
}publicstaticvoidmain(String[] args) {
HandleExcelFile hef=newHandleExcelFile();
hef.writeExcel();
}
}
测试读取程序，结果为