public class Sdemo { public static void main(String[] args) throws Exception { HSSFWorkbook wb = new HSSFWorkbook();//创建HSSFWorkbook对象 int n=0; HSSFSheet sheet = wb.createSheet("秩序册");//建立sheet对象 // sheet.setColumnWidth(0, sheet.getColumnWidth(0)); HSSFRow row1 = sheet.createRow(0); //在sheet里创建第一行,参数为行索引 row1.setHeight((short) (51 * 20)); HSSFCell cell = row1.createCell(0); //创建单元格 HSSFCellStyle columnTopStyle = getColumnTopStyle(wb);//获取列头样式对象 HSSFCellStyle style = getStyle(wb); style.setFillForegroundColor(IndexedColors.LIGHT_ORANGE.getIndex());// 设置背景色 style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); //设置加粗 HSSFCellStyle styleGroup = getStyle(wb); styleGroup.setFillForegroundColor(IndexedColors.LIME.getIndex());// 设置背景色 styleGroup.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); //设置加粗 HSSFCellStyle styleGroupCenter = getStyle(wb); HSSFCellStyle styleGroupLeft = getStyle(wb); styleGroupLeft.setFillForegroundColor(IndexedColors.TAN.getIndex());// 设置背景色 styleGroupLeft.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); //设置加粗 cell.setCellValue("U12组男子单打 第一阶段"); //设置单元格内容 cell.setCellStyle(columnTopStyle); //合并单元格CellRangeAddress构造参数依次表示起始行,截至行,起始列, 截至列 int a = 1; sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 12)); HashMap<String, HSSFRow> map = new HashMap<>(); HSSFFont font = wb.createFont(); font.setUnderline(Font.U_SINGLE); //下划线 //map存储时间 //在sheet里创建第二行 sheet.setColumnWidth(0, 256 * 4 + 184); for (int x = 0; x < 3; x++) { for (int j = 0; j < 10 + 1; j++) {//对阵数据 HSSFRow row2 = sheet.createRow(a + j); map.put(a+j+"",row2); if (j == 0) { row2.setHeight((short) (30 * 20)); } //查询是否有相同的时间 //创建单元格并设置单元格内容 for (int i = 0; i < 4; i++) { switch (i) { case 0: HSSFCell cell1 = row2.createCell(0); sheet.setColumnWidth(i, 256 * 5 + 184); // sheet.setColumnWidth(i, "对阵".getBytes().length*2*256); if (j == 0) { cell1.s
poi制作excel(循环表)
最新推荐文章于 2023-06-30 10:07:59 发布