我正在使用Apache POI的HSSFWorkbook将数据写入Excel电子表格.
我想整整一行加粗.有人可以建议怎么做吗?
解决方法
像这样的东西可以用你所拥有的东西:
- public static void makeRowBold(Workbook wb,Row row){
- CellStyle style = wb.createCellStyle();//Create style
- Font font = wb.createFont();//Create font
- font.setBold(true);//Make font bold
- style.setFont(font);//set it to bold
- for(int i = 0; i < row.getLastCellNum(); i++){//For each cell in the row
- row.getCell(i).setCellStyle(style);//Set the style
- }
- }
它基本上遍历传入的行中的每个单元格,将样式设置为粗体.应该导致整行被设置为所需的样式.
祝好运!
编辑
一个更完整的例子:
- public static void main(String[] args) {
- Path myFile = Paths.get(System.getProperty("user.home"),"Desktop","tester.xlsx");
- try {
- XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(myFile.toFile()));
- XSSFSheet sheet = wb.getSheetAt(0);
- makeRowBold(wb,sheet.getRow(0));
- wb.write(new FileOutputStream(myFile.toFile()));
- } catch (IOException e) {
- e.printStackTrace();
- }
- }
- public static void makeRowBold(Workbook wb,Row row){
- CellStyle style = wb.createCellStyle();//Create style
- Font font = wb.createFont();//Create font
- font.setBold(true);//Make font bold
- style.setFont(font);//set it to bold
- for(int i = 0; i < row.getLastCellNum(); i++){//For each cell in the row
- row.getCell(i).setCellStyle(style);//Set the sty;e
- }
- }