poi设置Excel单元格边框 和 背景色，java设置Excel 单元格边框 和 背景色
import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.util.HSSFColor;import org.apache.poi.ss.usermodel.BorderStyle;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.FillPatternType;import org.apache.poi.ss.usermodel.IndexedColors;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.OutputStream;/*** @ClassName 类名：ExcelDemo5* @Author作者: hzh* @Date时间：/12/4 13:41* 单元格边框 和 背景色**/public class ExcelDemo5 {public static void main(String[] args) throws Exception {Workbook wb = new HSSFWorkbook();Sheet sheet = wb.createSheet("一个sheet");Row row = sheet.createRow(3); //第一行Cell cell = row.createCell(3); //第一列cell.setCellValue("哈哈");CellStyle cellStyle = wb.createCellStyle(); //创建一个样式cellStyle.setBorderBottom(BorderStyle.DOUBLE); //底部边框cellStyle.setBottomBorderColor(HSSFColor.YELLOW.index);//底部边框颜色cellStyle.setBorderLeft(BorderStyle.MEDIUM_DASH_DOT_DOT); //左边框cellStyle.setLeftBorderColor(HSSFColor.RED.index);//左边框颜色cellStyle.setFillForegroundColor(IndexedColors.RED.getIndex()); //设置背景色cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);cell.setCellStyle(cellStyle);FileOutputStream fileOutputStream = new FileOutputStream("D://file//工作薄2.xls");wb.write(fileOutputStream);wb.close();}}
