poi导出excel在单元格内画斜线

来源:互联网 发布:sql nvl to_number 编辑:程序博客网 时间:2024/04/27 16:33
HSSFSheet sheet = workbook.getSheet("123");HSSFRow row = sheet.getRow(0);HSSFCell cell0 = row.getCell(0);        cell0.setCellValue("学号            信息") ;          //画线(由左上到右下的斜线)  在A1的第一个cell(单位  分类)加入一条对角线         HSSFPatriarch patriarch = sheet.createDrawingPatriarch();          HSSFClientAnchor a = new HSSFClientAnchor(0, 0, 1023, 255, (short)0, 0, (short)0, 0);          HSSFSimpleShape shape1 = patriarch.createSimpleShape(a);          shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);           shape1.setLineStyle(HSSFSimpleShape.LINESTYLE_SOLID) ;  



原创粉丝点击