一、设置响应的文件类型格式为电子表格格式
WritableWorkbook web = null;
ServletOutputStream sos=null;
// 设置响应的类型格式为电子表格格式
response.setContentType("application/vnd.ms-excel;charset=utf-8");
try {
response.setHeader("Content-Disposition", "attachment; filename="
+ new String("文件名".getBytes("gb2312"),"ISO8859-1")+".xls");
} catch (UnsupportedEncodingException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
二、创建excel表空间
sos=response.getOutputStream();
web = Workbook.createWorkbook(sos);
WritableSheet ws = web.createSheet("商户采购订单信息", 0);
三、设置表格中的字体大小
WritableFont titleFont = new WritableFont(WritableFont.createFont("宋体"),16,WritableFont.BOLD);
四、数据格式:字体居中
WritableCellFormat titleFormat = new WritableCellFormat(titleFont);
titleFormat.setAlignment(Alignment.CENTRE);
titleFormat.setVerticalAlignment(VerticalAlignment.CENTRE);
五、合并单元格
参数:列、行、列、行;比如:第一行第一列到第一行第七列合并
ws.mergeCells(0,0,7,0);