poi导出Excel

public void exporMovieExcel(){
List list=ms.queryAll();
//创建一个工作簿(创建一个excel文件)
XSSFWorkbook workbook=new XSSFWorkbook();
//创建一个单元格样式
XSSFCellStyle createCellStyle = workbook.createCellStyle();
//设置背景颜色
createCellStyle.setFillForegroundColor(new XSSFColor(Color.red));
//设置背景色填充模式
createCellStyle.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);
//创建一个字体
XSSFFont font = workbook.createFont();
font.setBold(true);
createCellStyle.setFont(font);
//设置文字水平居中
createCellStyle.setAlignment(HorizontalAlignment.CENTER);

	//创建一个工作表
 XSSFSheet sheet =workbook.createSheet();
 
//创建一个新行(表头行)
XSSFCellStyle cellstyle2=workbook.createCellStyle();
cellstyle2.setAlignment(HorizontalAlignment.CENTER);
XSSFRow row = sheet.createRow(0);
XSSFCell cell = row.createCell(0);
cell.setCellStyle(cellstyle2);
cell.setCellValue("电影管理系统");
CellRangeAddress address=new CellRangeAddress(0,0,0,8);
sheet.addMergedRegion(address);


//创建一个新行(表头行)

XSSFRow headerRow = sheet.createRow(1);
String[] headerNameArr=new String[]{"名称","海报","评分","简介","上映时间","录入时间","修改时间","类型"}; 
for (int i = 0; i < headerNameArr.length; i++) {
	XSSFCell headCell = headerRow.createCell(i);
	headCell.setCellValue(headerNameArr[i]);
	headCell.setCellStyle(createCellStyle);
}

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//循环遍历电影集合并创建新行
for (int i = 0; i < list.size(); i++) {
	XSSFRow dataRow = sheet.createRow(i+2);
	XSSFCell movieName = dataRow.createCell(0);
	movieName.setCellValue(list.get(i).getName());
	
	XSSFCell url = dataRow.createCell(1);
	url.setCellValue(list.get(i).getPosterUrl());

	XSSFCell grade = dataRow.createCell(2);
	grade.setCellValue(list.get(i).getGrade());
	
	XSSFCell introduction = dataRow.createCell(3);
	introduction.setCellValue(list.get(i).getIntroduction());
	
	XSSFCell showTime = dataRow.createCell(4);
	showTime.setCellValue(sdf.format(list.get(i).getShowTime()));
	
	XSSFCell createTime = dataRow.createCell(5);
	createTime.setCellValue(sdf.format(list.get(i).getCreateTime()));
	
	XSSFCell updateTime = dataRow.createCell(6);
	updateTime.setCellValue(list.get(i).getUpdateTime()!=null?sdf.format(list.get(i).getUpdateTime()):"");
	
	XSSFCell type = dataRow.createCell(7);
	type.setCellValue(list.get(i).getTypeid().getName());
}
com.fh.Util.ExcelUtil.excelDownload(workbook, getRequest(), getResponse(), UUID.randomUUID().toString()+".xlsx");

}