Question

java操作poi的excel表格的线条怎么变为黑色？

Answer 1

你跑下下面的代码试下吧：
public TestExcel(){
createExcelFile();
}

private void createExcelFile() {
HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("test sheet");
//创建一个样式
HSSFCellStyle style = hwb.createCellStyle();
//设置边框样式
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
//设置边框颜色
style.setTopBorderColor(HSSFColor.BLACK.index);
style.setBottomBorderColor(HSSFColor.BLACK.index);
style.setLeftBorderColor(HSSFColor.BLACK.index);
style.setRightBorderColor(HSSFColor.BLACK.index);

for(int j=0;j<5;j++){
HSSFRow row = sheet.createRow(j);
for(int i=0;i<10;i++){
HSSFCell cell = row.createCell(i);
cell.setCellStyle(style);
cell.setCellValue(j+"*"+i);
}
}
File file = new File("./test.xls");
try {
FileOutputStream fos = new FileOutputStream(file);
hwb.write(fos);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}

Answer 2

Java中设置表格边线颜色：

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. }

参考自：网页链接