java导出Excel,
java导出Excel,
public boolean exportExcel(HttpServletResponse response, List list){
try
{
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
String filename = sdf.format(new Date())+".xls";
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();// 清空输出流
response.setHeader("Content-disposition", "attachment; filename="+filename);// 设定输出文件头
response.setContentType("application/vnd.ms-excel");// 定义输出类型
WritableWorkbook wbook = Workbook.createWorkbook(os); // 建立excel文件
String tmptitle = ""; // 标题
WritableSheet wsheet = wbook.createSheet(tmptitle, 0); // sheet名称
WritableFont wfont = new jxl.write.WritableFont(WritableFont.ARIAL, 14,WritableFont.BOLD,
false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK);
WritableCellFormat wcfFC = new WritableCellFormat(wfont);
wcfFC.setBackground(Colour.WHITE);
// 开始生成主体内容
wsheet.addCell(new Label(0, 0, ""));
wsheet.addCell(new Label(1, 0, ""));
for(int i=0;i<list.size();i++){
List temp = (List)list.get(i);
wsheet.addCell(new Label(0, i+1, (String)temp.get(0)));
wsheet.addCell(new Label(1, i+1, (String)temp.get(1)));
}
// 主体内容生成结束
wbook.write(); // 写入文件
wbook.close();
os.close(); // 关闭流
return true;
} catch(Exception e) {
log.error(e.getMessage());
return false;
}
}
相关文章
- 暂无相关文章
用户点评