public String genarateExcel() {
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("企业信息管理");
HSSFRow row = sheet.createRow(0);
HSSFCellStyle style = workbook.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
// 生成表头
HSSFCell cell = row.createCell(0);
cell.setCellValue("企业名称");
cell.setCellStyle(style);
cell = row.createCell(1);
cell.setCellValue("状态");
cell.setCellStyle(style);
cell = row.createCell(2);
cell.setCellValue("法人代表");
cell.setCellStyle(style);
cell = row.createCell(3);
cell.setCellValue("创建时间");
List<Info> list = super.copyList(infoDao.selectAll(),Info.class);
for (int i = 0; i < list.size(); i++) {
row = sheet.createRow(i + 1);
Info info = list.get(i);
row.createCell(0).setCellValue(info.getEntpName());
if ("1".equals(info.getEntpState())) {
row.createCell(1).setCellValue("正常");
}else {
row.createCell(1).setCellValue("不启用");
}
row.createCell(2).setCellValue(info.getEntpLegalName());
row.createCell(3).setCellValue(info.getCreateTime());
}
String filePath = "/home/javaweb/webresource/static/exportFile/BusinessManagement.xls";
try {
FileOutputStream fout = new FileOutputStream(filePath);
workbook.write(fout);
fout.close();
} catch (Exception e) {
e.printStackTrace();
}
String urlPath = "http://123.207.37.53/exportFile/BusinessManagement.xls";
return urlPath;
}
先要在文件夹建好目录,在访问外网路径进行下载