采用apache 【POI】 框架生成excel文件
public static void CreateBugFile(String fileName, String bussinessNo, String projectPath) throws Exception {File bugFile = new File(fileName + ".xls");
File file = new File(projectPath);
String[] titles = { "代码变更说明", "所属子系统", "代码路径", "修改人", "业务单号", "备注" };
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("代码导入");
HSSFCellStyle hssfCellStyle = workbook.createCellStyle();
hssfCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
hssfCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
hssfCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
hssfCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
hssfCellStyle.setVerticalAlignment(HSSFCellStyle.ALIGN_LEFT);
//hssfCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
// hssfCellStyle.setRightBorderColor(HSSFCellStyle.BORDER_THIN);
// hssfCellStyle.setLeftBorderColor(HSSFCellStyle.BORDER_THIN);
HSSFRow hssfRow = sheet.createRow(0);
for (int i = 0, j = titles.length; i < j; i++) {
HSSFCell hssfCell = hssfRow.createCell(i);
if (i == 2) {
sheet.setColumnWidth(i, 10000);
} else {
sheet.setColumnWidth(i, 5000);
}
hssfCell.setCellValue(titles.trim());
hssfCell.setCellStyle(hssfCellStyle);
}
for (int i = 0; i < list.size(); i++) {
HSSFRow hssfRow2 = sheet.createRow(i + 1);
for (int m = 0; m < 6; m++) {
HSSFCell hssfCell = hssfRow2.createCell(m);
if (m == 0) {
sheet.setColumnWidth(m, 5000);
hssfCell.setCellValue(codeChangeDesc.trim());
} else if (m == 1) {
sheet.setColumnWidth(m, 5000);
hssfCell.setCellValue(childSys.trim());
} else if (m == 2) {
sheet.setColumnWidth(m, 10000);
hssfCell.setCellValue(list.get(i).toString().trim());
} else if (m == 3) {
sheet.setColumnWidth(m, 5000);
hssfCell.setCellValue(updater.trim());
} else if (m == 4) {
sheet.setColumnWidth(m, 5000);
hssfCell.setCellValue(bussinessNo.trim());
} else if (m == 5) {
sheet.setColumnWidth(m, 5000);
hssfCell.setCellValue(remark.trim());
}
// sheet.setColumnWidth(m, 5000);
hssfCell.setCellStyle(hssfCellStyle);
}
}
FileOutputStream fileOutputStream = new FileOutputStream(bugFile);
workbook.write(fileOutputStream);
fileOutputStream.close();
}
页:
[1]