freemarker导出复杂样式的Excel

            <#list products as product>
                <Row>
                    <Cell>
                        <Data ss:Type="String">${product.name!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.number!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.type!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.unit!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.left!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.monthNumber!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.in!}</Data>
                    </Cell>
                    <Cell>
                        <Data ss:Type="String">${product.out!}</Data>
                    </Cell>
                    <Cell ss:StyleID="s54">
                        <Data ss:Type="String">${product.date?string('yyyy/MM/dd')}</Data>
                    </Cell>
                </Row>
            </#list>

@Controller
public class AppController {
	@Autowired
	private Configuration configuration;

	@RequestMapping("/export")
	public void export(HttpServletResponse response) throws Exception {
		//自己封装号数据实体
		ArrayList<Product> products = new ArrayList<>();

		//构造数据
		for (int i = 0; i < 100; i++) {
			Product e = new Product();
			e.setName(RandomUtil.randomString(5));
			e.setNumber(RandomUtil.randomString(2));
			e.setOut(RandomUtil.randomString(2));
			e.setIn(RandomUtil.randomString(2));
			e.setType(RandomUtil.randomString(5));
			e.setUnit(RandomUtil.randomString(4));
			e.setMonthNumber(RandomUtil.randomString(1));
			e.setDate(new Date());
			products.add(e);
		}
		HashMap<String, Object> map = new HashMap<>();
		map.put("products", products);

		//构造输出流
		Template template = configuration.getTemplate("2018库存表.xml", "UTF-8");
		String fileName = "/data/files/" + DateUtil.now() + ".xlsx";
		File file = new File(fileName);
		FileWriter out = new FileWriter(fileName);
		//变量替换
		template.process(map, out);

		//将文件输出到response,返回给客户端
		FileInputStream in = new FileInputStream(file);
		byte[] buffer = new byte[in.available()];
		in.read(buffer);
		in.close();
		response.reset();
		response.addHeader("Content-Disposition", "attachment;filename=file.xlsx");
		ServletOutputStream outputStream = response.getOutputStream();
		response.setContentType("application/octet-stream");
		outputStream.write(buffer);
		outputStream.flush();
		outputStream.close();
	}
}