java 操作execl

public void exportExcel(List xwList, String excelName) throws Exception {
String[] header = { "信访署名", "阅信人/接待人", "信访目的", "一级分类", "二级分类", "三级分类",
"人数", "信访形式", "主送单位/问题属地" }; // 列标题
File file=new File("G:\\test\\");
if(!file.exists()){file.mkdir();}
OutputStream os=new FileOutputStream("G:\\test\\"+"testexcel.xls");
WritableWorkbook book = Workbook.createWorkbook(os);
WritableSheet sheet = book.createSheet(excelName, 0);
WritableCellFormat wcf_header = getHeader();
WritableCellFormat wcf_center = getCellCls();
for (int i = 0; i < header.length; i++) {
sheet.addCell(new Label(i, 0, header[i], wcf_header));
}
int row = 1;
try {
for (int i = 0; i < xwList.size(); i++) {
Object[] obj = (Object[]) xwList.get(i);
sheet.addCell(new Label(0, row, StringUtil.isNull(obj[2]) ? ""
: obj[2].toString(), wcf_center));
sheet.setColumnView(0, 13);
sheet.addCell(new Label(1, row, StringUtil.isNull(obj[18]) ? ""
: obj[18].toString(), wcf_center));
sheet.setColumnView(1, 18);
sheet.addCell(new Label(2, row, StringUtil.isNull(obj[3]) ? ""
: obj[3].toString(), wcf_center));
sheet.setColumnView(2, 12);
sheet.addCell(new Label(3, row, StringUtil.isNull(obj[23]) ? ""
: obj[23].toString(), wcf_center));
sheet.setColumnView(3, 17);
sheet.addCell(new Label(4, row, StringUtil.isNull(obj[24]) ? ""
: obj[24].toString(), wcf_center));
sheet.setColumnView(4, 17);
sheet.addCell(new Label(5, row, StringUtil.isNull(obj[25]) ? ""
: obj[25].toString(), wcf_center));
sheet.setColumnView(5, 17);
sheet.addCell(new Label(6, row, StringUtil.isNull(obj[8]) ? ""
: obj[8].toString(), wcf_center));
sheet.setColumnView(6, 13);
sheet.addCell(new Label(7, row, StringUtil.isNull(obj[5]) ? ""
: obj[5].toString(), wcf_center));
sheet.setColumnView(7, 12);
sheet.addCell(new Label(8, row, StringUtil.isNull(obj[9]) ? ""
: obj[9].toString(), wcf_center));
sheet.setColumnView(8, 40);
row++;
}
} catch (Exception e) {
throw e;
}
}


// 设置header样式
public WritableCellFormat getHeader() throws Exception {
WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 13,
WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
jxl.format.Colour.WHITE);
WritableCellFormat wcf_title = new WritableCellFormat(titleFont);
wcf_title.setBackground(Colour.GRAY_25, Pattern.SOLID);
wcf_title.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);
wcf_title.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐
wcf_title.setAlignment(Alignment.CENTRE);
return wcf_title;
}

public WritableCellFormat getCellCls() throws Exception {
WritableFont NormalFont = new WritableFont(WritableFont.TAHOMA, 11);
WritableCellFormat wcf_center = new WritableCellFormat(NormalFont);
wcf_center.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);
wcf_center.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐
wcf_center.setAlignment(Alignment.LEFT);
return wcf_center;
}

public WritableCellFormat getTitleCls() throws Exception {
WritableFont font = new WritableFont(WritableFont.TIMES, 14,
WritableFont.BOLD);// 定义字体
WritableCellFormat format = new WritableCellFormat(font);
format.setAlignment(jxl.format.Alignment.CENTRE);// 左右居中
format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);// 上下居中
format.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);// 黑色边框
return format;
}