数据处理层:
List<File> fileList = new ArrayList<File>();
String[] array = {"编码","名称"};
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet("数据内容");
XSSFRow row = sheet.createRow(0);
XSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
for(int j = 0; j < array.length; j++){//循环表头
XSSFCell cell = row.createCell(j);
cell.setCellStyle(style);
cell.setCellValue(array[j]);
}
row = sheet.createRow(1);
row.createCell(0).setCellValue("123456");
row.createCell(1).setCellValue("小明");
FileOutputStream out = null;
File file = File.createTempFile("fileName_", ".xlsx");
out = FileUtils.openOutputStream(file);
wb.write(out);//将数据写到指定文件
fileList.add(file);
out.close();
wb