POI导出Excel的样式（使用的是spire）

        Workbook wb = new Workbook();
        String path ="C:\\wzmoffice\\upload\\excel\\";
        wb.loadFromFile( path+ "公示表.xlsx");

        //声明Workbook变量
        Workbook newWb = new Workbook();
        newWb.setVersion(wb.getVersion());
        Worksheet newSheet = newWb.getWorksheets().get("sheet1");

        CellStyle style2 = newWb.getStyles().addStyle("Data Style");
        //复制
        Worksheet orderSheet = wb.getWorksheets().get("sheet1");
        newSheet.copyFrom(orderSheet);
        for (int i = 5; i < 10; i++) {

            CellRange cellRange = newSheet.getCellRange(i, 1);
            cellRange.setValue("测试");
//            cellRange.setStyle(style2);

            cellRange.getBorders().setLineStyle(LineStyleType.MediumDashDot);
            cellRange.getBorders().getByBordersLineType(BordersLineType.DiagonalDown).setLineStyle(LineStyleType.None);
            cellRange.getBorders().getByBordersLineType(BordersLineType.DiagonalUp).setLineStyle(LineStyleType.None);
            cellRange.getBorders().setColor(Color.black);
        }

        newWb.saveToFile(path+"demo"+".xlsx", ExcelVersion.Version2016);

边框线样式：LineStyleType.MediumDashDot：加粗的线段
LineStyleType（没有边框线）
thin（普通边框线）