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對象  } }}