poi 操作excel常用方法

POI操作Excel常用方法

自定义颜色
HSSFCellStyle style = wb.createCellStyle();    
style.setFillForegroundColor(HSSFColor.LIME.index);    
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);    
HSSFFont font = wb.createFont();    
font.setColor(HSSFColor.RED.index);    
style.setFont(font);    
cell.setCellStyle(style);    

填充和颜色设置
HSSFCellStyle style = wb.createCellStyle();    
style.setFillBackgroundColor(HSSFColor.AQUA.index);    
style.setFillPattern(HSSFCellStyle.BIG_SPOTS);    
HSSFCell cell = row.createCell((short) 1);    
cell.setCellValue("X");    
style = wb.createCellStyle();    
style.setFillForegroundColor(HSSFColor.ORANGE.index);    
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);    
cell.setCellStyle(style);  

复制sheet页并调整位置
Sheet newSheet = workbook.cloneSheet(newSheetIndex);
workbook.setSheetOrder(newSheet.getSheetName(), newSheetIndex+1);
workbook.setSheetName(newSheetIndex+1, "机房-"+(newSheetIndex+1));

合并单元格
sheet.addMergedRegion(new CellRangeAddress(rowspanStartNumber, rowspanEndNumber, colspanStartNumber, colspanEndNumber));