java操作poi的excel表格的线条怎么变为黑色？-poi设置excel单元格格式设置,poi设置单元格格式为数字

应该是没有、 这也好实现，自己写个方法，循环每一个单元格来弄吧

Java中设置表格边线颜色e69da5e887aae79fa5e98193332：

1. import com.spire.xls.*;

2. import java.awt.*;

3.  

4. public class AddBorders {

5.     public static void main(String[] args){

6.         //Create a workbook instance

7.         Workbook workbook = new Workbook();

8.         //Load the Excel file

9.         workbook.loadFromFile("Sample-SetBorder.xlsx");

10.  

11.         //Get the first worksheet

12.         Worksheet sheet = workbook.getWorksheets().get(0);

13.  

14.         //Get the cell range that you want to apply border style

15.         CellRange cr = sheet.getCellRange(sheet.getFirstRow(), sheet.getFirstColumn(), sheet.getLastRow(), sheet.getLastColumn());

16.  

17.         //Apply border style

18.         cr.getBorders().setLineStyle(LineStyleType.Double);

19.         cr.getBorders().getByBordersLineType(BordersLineType.DiagonalDown).setLineStyle(LineStyleType.None);

20.         cr.getBorders().getByBordersLineType(BordersLineType.DiagonalUp).setLineStyle(LineStyleType.None);

21.         cr.getBorders().setColor(Color.BLUE);

22.  

23.         //Save the resultant file

24.         workbook.saveToFile("SetBorder.xlsx", ExcelVersion.Version2010);

25.     }

26. }

参考自：网页链接

参考自代百码度知 public static void createColHeader(HSSFSheet sheet, CellStyle cellStyle,String[] columHeader) {if (sheet !道= null) { sheet.setDefaultColumnWidth(20); HSSFRow row = sheet.createRow(0); for (int i = 0; i < columHeader.length; i++) { HSSFCell cell = row.createCell(i); cell.setCellValue(columHeader[i]); if (cellStyle != null) { cell.setCellStyle(cellStyle); } } freezePane(sheet,0,1,0,1); }}

cellStyle.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 下边答框版
cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);// 左边框
cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);// 上边权框
cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);// 右边框