java jxl 多页签,java 用jxl將多個excel文件合併成一個多sheet的excel文件 | 學步園

String url="F:/test/temp1404713514264.xls"+","+"F:/test/temp1404887145242.xls"+","+"F:/test/temp1404887150705.xls";

String[] fList=url.split(",");

try {

if(fList.length > 0){

//生成文件路徑

tempFile="F:/test/test.xls";

//合併生成

newWb = Workbook.createWorkbook(new File(tempFile));

//輸出流

for(int i=0;i

//文件名

String fileName=fList[i];

is=new FileInputStream("F:/test/test.xls");

is=new FileInputStream(fileName);

wb=null;

wb=Workbook.getWorkbook(is);

Sheet st =null;

st=wb.getSheet(0);

newWb.importSheet(st.getCell(0, 0).getContents(), i, st);

WritableSheet sheet = null;

sheet=newWb.getSheet(i);

for (int row = 0; row < st.getRows(); row++) {

for (int col = 0; col < st.getColumns(); col++) {

//單元格值

String value=st.getCell(col, row).getContents();

//判斷在需要的表格範圍內,添加樣式

if(ElaneUtil.isNotEmpty(value)){

//判斷是否為數字

if(ElaneUtil.isNumeric(value)){

//數字格式

jxl.write.Number labelNF;

//格式化數值(數字)

labelNF = new jxl.write.Number(col, row, UtilFunction.parseDouble(value));

WritableCellFormat format1 = new WritableCellFormat();

//填充白色(單元格背景顏色)

format1.setBackground(jxl.format.Colour.WHITE);

//設置邊框顏色

format1.setBorder(Border.ALL, BorderLineStyle.THIN,Colour.GRAY_25);

labelNF.setCellFormat(format1);

sheet.addCell(labelNF);

}

}else{

//單元格 標籤

Label label = new jxl.write.Label(col, row, value);

//沒有值的地方,設置樣式

WritableCellFormat format2 = new WritableCellFormat();

//填充白色(單元格背景顏色)

format2.setBackground(jxl.format.Colour.WHITE);

//設置邊框顏色

format2.setBorder(Border.ALL, BorderLineStyle.THIN,Colour.GRAY_25);

label.setCellFormat(format2);

sheet.addCell(label);

}

}

}

is.close();

wb.close();

}

newWb.write();

newWb.close();

}

} catch (BiffException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} catch (WriteException e) {

e.printStackTrace();

}finally{

try {

if(is!=null){

is.close();

}

if(wb!=null){

wb.close();

}

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}