/**
* 导出信息
* @date 2011-6-10
*/
public void exportMatchangeExcel(QueryVo queryVo) {
WritableWorkbook workbook = null;
try{
HttpServletResponse response = ServletActionContext.getResponse();
OutputStream outPutS = response.getOutputStream();
response.resetBuffer();
response.setHeader("Content-Type", "application/force-download;");
//中文名:name = new String(name.getBytes("GBK"),"UTF-8");
response.setHeader("Content-disposition", "attachment;filename=matchange--"+FDateFormat.GetShortDate()+".xls");
response.setContentType("application/excel");
workbook = Workbook.createWorkbook(outPutS);
WritableSheet sheet = workbook.createSheet("仓库物料进出库信息", 0);
String title[] = {"序号","物料号"};
Label label = null;
/** 字体设置 */
WritableFont headerFont = new WritableFont(WritableFont.ARIAL, 12,
WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
Colour.BLACK);
/** 格式 */
WritableCellFormat headerFormat = new WritableCellFormat(headerFont);
headerFormat.setAlignment(Alignment.CENTRE);
headerFormat.setBorder(Border.ALL, BorderLineStyle.THIN,
Colour.BLACK);
WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 10,
WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
Colour.BLACK);
WritableCellFormat titleFormat = new WritableCellFormat(titleFont);
titleFormat.setAlignment(Alignment.CENTRE);
titleFormat.setBorder(Border.ALL, BorderLineStyle.THIN,
Colour.BLACK);
WritableFont columnNameFont = new WritableFont(WritableFont.ARIAL,
10, WritableFont.NO_BOLD, false,
UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
WritableCellFormat columnNameFormat = new WritableCellFormat(
columnNameFont);
columnNameFormat.setAlignment(Alignment.CENTRE);
columnNameFormat.setBorder(Border.ALL, BorderLineStyle.THIN,
Colour.BLACK);
WritableCellFormat columnNameFormatLeft = new WritableCellFormat(
columnNameFont);
columnNameFormatLeft.setAlignment(Alignment.LEFT);
columnNameFormatLeft.setBorder(Border.ALL, BorderLineStyle.THIN,
Colour.BLACK);
sheet.mergeCells(0, 0, 13, 0);//第一个参数:开始列,第二个参数:开始行,第三个参数:结束列,第四个参数:结束行,
label = new Label(0, 0, "[仓库物料进出库信息列表--"+FDateFormat.GetLongDate()+"]", headerFormat);
sheet.addCell(label);
int index=0;//行索引
int row = 1;//行数
int column = 0;
for (int i = 0; i < title.length; i++) {
label = new Label(column++, 1, title[i], titleFormat);
sheet.addCell(label);
}
jxl.write.Number labelNF = null;
if(dsbfMatchangeList != null){
for(KdDsbfMatchangeVo dsbfMatchangeVo : dsbfMatchangeList){
++index;
row++;
column = 0;
//序号
labelNF = new jxl.write.Number(column++, row,index,columnNameFormat);
sheet.addCell(labelNF);
//物料号
label = new Label(column++, row,物料号,columnNameFormat);
sheet.addCell(label);
}
}
column = 0;
/* 设置长度 */
sheet.setColumnView(column++, 5 );//0
sheet.setColumnView(column++, 12);//1
// 写入数据
workbook.write();
}catch(Exception e){
e.printStackTrace();
}finally{
try {
workbook.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
java用jxl包导出Excel的例子
最新推荐文章于 2021-03-05 01:49:33 发布