表格导出的样式

深藏阁楼爱情的钟 2022-06-09 06:42 279阅读 0赞

HSSFSheet sheet = workbook.createSheet(“sheetName”); //创建sheet  
sheet.setVerticallyCenter(true);

//下面样式可作为导出左右分栏的表格模板  
sheet.setColumnWidth((short) 0, (short) 2600);// 设置列宽  
sheet.setColumnWidth((short) 1, (short) 2400);  
sheet.setColumnWidth((short) 2, (short) 2300);  
sheet.setColumnWidth((short) 3, (short) 1600);  
sheet.setColumnWidth((short) 4, (short) 1800);  
sheet.setColumnWidth((short) 5, (short) 1000);// 空列设置小一些  
sheet.setColumnWidth((short) 6, (short) 2600);// 设置列宽  
sheet.setColumnWidth((short) 7, (short) 2400);  
sheet.setColumnWidth((short) 8, (short) 2300);  
sheet.setColumnWidth((short) 9, (short) 1600);  
sheet.setColumnWidth((short) 10, (short) 1800);

HSSFCellStyle cellstyle = (HSSFCellStyle) workbook.createCellStyle();// 设置表头样式  
cellstyle.setAlignment(HSSFCellStyle.ALIGN\_CENTER);// 设置居中

HSSFCellStyle headerStyle = (HSSFCellStyle) workbook .createCellStyle();// 创建标题样式  
headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER); //设置垂直居中  
headerStyle.setAlignment(HSSFCellStyle.ALIGN\_CENTER); //设置水平居中  
HSSFFont headerFont = (HSSFFont) workbook.createFont(); //创建字体样式  
headerFont.setBoldweight(HSSFFont.BOLDWEIGHT\_BOLD); // 字体加粗  
headerFont.setFontName(“Times New Roman”); //设置字体类型  
headerFont.setFontHeightInPoints((short) 8); //设置字体大小  
headerStyle.setFont(headerFont); //为标题样式设置字体样式

HSSFCellStyle headerStyle1 = (HSSFCellStyle) workbook .createCellStyle();// 创建标题样式1  
headerStyle1.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER);  
headerStyle1.setAlignment(HSSFCellStyle.ALIGN\_CENTER);  
HSSFFont headerFont1 = (HSSFFont) workbook.createFont();  
headerFont1.setBoldweight(HSSFFont.BOLDWEIGHT\_BOLD);// 字体加粗  
headerFont1.setFontName(“Times New Roman”);  
headerFont1.setFontHeightInPoints((short) 8);  
headerStyle1.setFont(headerFont1);

HSSFCellStyle headerStyle2 = (HSSFCellStyle) workbook .createCellStyle();// 创建标题样式2  
headerStyle2.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER);  
headerStyle2.setAlignment(HSSFCellStyle.ALIGN\_CENTER);  
HSSFFont headerFont2 = (HSSFFont) workbook.createFont();  
headerFont2.setBoldweight(HSSFFont.BOLDWEIGHT\_BOLD);// 字体加粗  
headerFont2.setFontName(“Times New Roman”);  
headerFont2.setFontHeightInPoints((short) 8);  
headerStyle2.setFont(headerFont2);  
headerStyle2.setBorderBottom(HSSFCellStyle.BORDER\_THIN); // 下边框  
headerStyle2.setBorderLeft(HSSFCellStyle.BORDER\_THIN);// 左边框  
headerStyle2.setBorderTop(HSSFCellStyle.BORDER\_THIN);// 上边框  
headerStyle2.setBorderRight(HSSFCellStyle.BORDER\_THIN);// 右边框

HSSFCellStyle cell\_Style = (HSSFCellStyle) workbook .createCellStyle();// 设置字体样式  
cell\_Style.setAlignment(HSSFCellStyle.ALIGN\_CENTER);  
cell\_Style.setVerticalAlignment(HSSFCellStyle.VERTICAL\_CENTER);// 垂直对齐居中  
cell\_Style.setWrapText(true); // 设置为自动换行  
HSSFFont cell\_Font = (HSSFFont) workbook.createFont();  
cell\_Font.setFontName(“宋体”);  
cell\_Font.setFontHeightInPoints((short) 8);  
cell\_Style.setFont(cell\_Font);  
cell\_Style.setBorderBottom(HSSFCellStyle.BORDER\_THIN); // 下边框  
cell\_Style.setBorderLeft(HSSFCellStyle.BORDER\_THIN);// 左边框  
cell\_Style.setBorderTop(HSSFCellStyle.BORDER\_THIN);// 上边框  
cell\_Style.setBorderRight(HSSFCellStyle.BORDER\_THIN);// 右边框

HSSFRow row = sheet.createRow((short)1); //创建行  
HSSFCell cell = row.createCell((short)1); //创建列  
cell.setCellStyle(headerStyle2); //单元格引用样式