本文實例講述了Jexcel實現按一定規則分割excel文件的方法。分享給大家供大家參考。具體如下：
現有一個excel文檔，需要讀取它並按照一定的規則，分割之，分割出來的每一段記錄需要單獨創建一個excel文檔並寫入其中，一定要保證單元格格式的一致性。
package edu.bjut.zhutong.excelParser;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import jxl.Cell;import jxl.CellType;import jxl.Sheet;import jxl.Workbook;import jxl.format.Alignment;import jxl.format.Border;import jxl.format.BorderLineStyle;import jxl.format.Colour;import jxl.format.VerticalAlignment;import jxl.read.biff.BiffException;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;import jxl.write.WriteException; import jxl.write.biff.RowsExceededException;public class ExcelParser { public static void main(String[] args) { Workbook wb = null; try { //獲得了Workbook對象之後，就可以通過它得到Sheet（工作表）對象了InputStream is = new FileInputStream("C:/excel/excel.xls"); wb = Workbook.getWorkbook(is); // 獲得第一個工作表對象Sheet sheet = wb.getSheet(0); //獲得工作表的行數和列數int rows = sheet.getRows(); int cols = sheet.getColumns(); System.out.println("一共" + rows + " 行"); System.out.println("一共" + cols + " 列"); int counter = 0; //工作表行游標int fileCounts = 1; //用來標識創建的excel文檔數目while(counter<rows-1) { //得到counter行的所有單元格Cell[] rowCells = sheet.getRow(counter); Cell cell0 = rowCells[0]; //判斷單元格內容的類型if(cell0.getType() == CellType.LABEL) { System.out. println("正在解析第" + fileCounts + " 個文件...."); //新建一個excel文檔File file = new File("C:/excel/excel" + fileCounts + ".xls"); WritableWorkbook wwb = Workbook.createWorkbook(file); //設置excel文檔的工作表WritableSheet ws = wwb.createSheet("sheet1", 0); //第一行合併第0到第8列ws.mergeCells(0, 0 , 8, 0); //設置第7,8,9列的列寬ws.setColumnView(6, 10); ws.setColumnView(7, 45); ws.setColumnView(8, 27); //向新建的表中寫入數據，首先第一行先寫入標題for(int k=0; k<rowCells.length; k++) { //創建WritableFont對像用來格式化字體，這裡是20號宋體，加粗WritableFont wf = new WritableFont(WritableFont.createFont("宋體"), 20, WritableFont.BOLD, false); //使用WritableFont創建單元格格式化對象WritableCellFormat wcf = new WritableCellFormat(wf); //設置水平對齊方式wcf .setAlignment(Alignment.CENTRE); //設置垂直對齊方式wcf.setVerticalAlignment(VerticalAlignment.CENTRE); //設置邊框和顏色wcf.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK); Cell cell = rowCells [k]; Label label = new Label(k,0,cell.getContents(),wcf); //添加單元格到表中ws.addCell(label); //設置第一行的行高ws.setRowView (0, 30*20, false); } //向新建的表中寫入數據，第二行寫入表頭for(int c=0; c<cols; c++) { String colCon = sheet.getCell( c, 1).getContents(); WritableFont wf = new WritableFont(WritableFont.createFont("宋體"), 12, WritableFont.BOLD, false); WritableCellFormat wcf = new WritableCellFormat(wf); wcf.setAlignment(Alignment.CENTRE) ; wcf.setVerticalAlignment(VerticalAlignment.CENTRE); wcf.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK); ws.addCell(new Label(c,1,colCon,wcf)); ws.setRowView(1, 18*20, false); } int rowCounts = 1; //用來遍歷50 counter++; //將游標移動到下一行if(counter == 1) //如果游標到了第二行，就自動把游標移動到第三行，第二行不需要處理counter = 2; int rowIndex = 2; //每篇excel文檔的游標rowCells = sheet.getRow(counter); cell0 = rowCells[0]; while(cell0.getType( ) == CellType.NUMBER && counter<rows-1) { rowCells = sheet.getRow(counter); for(int k=0; k<rowCells.length; k++) { WritableFont wf = new WritableFont(WritableFont.createFont("宋體"), 12, WritableFont.NO_BOLD, false); WritableCellFormat wcf = new WritableCellFormat(wf); wcf.setAlignment(Alignment.CENTRE); wcf.setVerticalAlignment(VerticalAlignment.CENTRE); wcf.setBorder(Border.ALL, BorderLineStyle. THIN, Colour.BLACK); Label label = new Label(k,rowIndex,rowCells[k].getContents(),wcf); ws.addCell(label); } //用來處理備註列的邊框{ WritableFont wf = new WritableFont(WritableFont.createFont("宋體"), 12, WritableFont.NO_BOLD, false); WritableCellFormat wcf = new WritableCellFormat(wf); wcf.setAlignment(Alignment.CENTRE); wcf.setVerticalAlignment(VerticalAlignment.CENTRE); wcf. setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK); Label label = new Label(8,rowIndex,"",wcf); ws.addCell(label); } ws.setRowView(rowIndex, 18*20, false ); rowIndex++; counter++; cell0 = sheet.getRow(counter)[0]; } wwb.write(); wwb.close(); fileCounts++; } } System.out.println("程序執行結束...." ); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (BiffException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (RowsExceededException e) { e. printStackTrace(); } catch (WriteException e) { e.printStackTrace(); } finally { wb.close(); //關閉Workbook對象} }}希望本文所述對大家的java程序設計有所幫助。