工具类:
public class ExcelUtils {
public static WritableWorkbook createTemplate(OutputStream output) throws IOException, WriteException {
WritableWorkbook writableWorkbook= Workbook.createWorkbook(output);
WritableSheet wsheet = writableWorkbook.createSheet(“模板”, 0);
CellFormat cf = writableWorkbook.getSheet(0).getCell(1, 0).getCellFormat();
WritableCellFormat wc = new WritableCellFormat();
// 设置居中
wc.setAlignment(Alignment.CENTRE);
// 设置边框线
// wc.setBorder(Border.ALL, BorderLineStyle.THIN);
wc.setBackground(jxl.format.Colour.GREEN);
Label nc0 = new Label(0, 0, "姓名",wc);//Label(x,y,z)其中x代表单元格的第x+1列,第y+1行, 单元格的内容是z
Label nc1 = new Label(1, 0, "性别",wc);
Label nc2 = new Label(2, 0, "年龄",wc);
Label nc3 = new Label(0, 1, "小红");
Label nc4 = new Label(1, 1, "男");
wsheet.addCell(nc0);
wsheet.addCell(nc1);
wsheet.addCell(nc2);
wsheet.addCell(nc3);
wsheet.addCell(nc4);
return writableWorkbook;
}
}
controller类:
@Controller
public class DownloadController {
@RequestMapping(“download”)
public void download(HttpServletRequest request, HttpServletResponse response)
throws IOException, BiffException, WriteException {
response.setHeader(“Content-Disposition”, “attachment; filename=template.xxls”);
WritableWorkbook writableWorkbook =
ExcelUtils.createTemplate(response.getOutputStream());
writableWorkbook.write();
writableWorkbook.close();
}
}