poi导出Excel，表格画斜线，并设置数据

以你之姓@ 2023-02-20 04:58 286阅读 0赞

## 效果图 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2w4NDgxNjg_size_16_color_FFFFFF_t_70]

## 画斜线代码如下： ##

ExportParams params = new ExportParams("【" + request.getYearStr() + "】花纹统计明细数据", "数据");
        params.setType(ExcelType.HSSF);
        Workbook workbook = ExcelExportUtil.exportExcel(params, colList, list);
        Sheet sheet = workbook.getSheetAt(0);
        Row row = sheet.getRow(1);
        Cell cell0 = row.getCell(0);
        cell0.setCellValue("花纹 月份");
        //画线(由左上到右下的斜线) 在A1的第一个cell（单位 分类）加入一条对角线
        HSSFPatriarch patriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
        HSSFClientAnchor a = new HSSFClientAnchor(0, 0, 1023, 255, (short) 0, 1, (short) 0, 2);
        HSSFSimpleShape shape1 = patriarch.createSimpleShape(a);
        shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
      	shape1.setLineStyle(HSSFSimpleShape.LINESTYLE_SOLID);

核心在于HSSFClientAnchor这个类，不懂的这时候可以百度了，我使用的是EasyPoi的框架，如果你是用ApachePoi直接从WorkBook开始看就行了。

## 白嫖到这，我劝你点个赞再走。 ##

**关注微信公众号，随时了解最新行业技术走向。**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2w4NDgxNjg_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2w4NDgxNjg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200623151352540.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2w4NDgxNjg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2w4NDgxNjg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200623154024906.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2w4NDgxNjg=,size_16,color_FFFFFF,t_70