java poi excel node

最新推荐文章于 2023-07-26 19:50:01 发布

carl99

最新推荐文章于 2023-07-26 19:50:01 发布

阅读量320

点赞数

本文链接：https://blog.csdn.net/icfhsfmf/article/details/50857823

版权

1.一個單元格多行顯示
HSSFCell cell = row.createCell((short)0);
cellStyle.setWrapText(true);//先设置为自动换行
cell.setCellStyle(cellStyle);
cell.setCellValue(new HSSFRichTextString(“hello\n world!”));

2.
这里写图片描述

private void createHead(HSSFSheet sheet, HSSFCellStyle groupStyle,
            HSSFCellStyle headStyle, HSSFCellStyle tipStyle, String name, Locale locale) {
        Map<String, String> messages = getMessages();

        /*控制*/
        HSSFRow rowTip = sheet.createRow(0);
        rowTip.setHeight((short)3000);
        HSSFCell cellTip = rowTip.createCell(0);
        cellTip.setCellStyle(tipStyle);
        cellTip.setCellValue(new HSSFRichTextString("12345\n12345\n12345"));
        ...
        ...
}

/*控制*/
private void setStyle(HSSFWorkbook workBook, HSSFCellStyle groupStyle,
            HSSFCellStyle headStyle, HSSFCellStyle conentStyle,
            HSSFCellStyle formatConentStyle, HSSFCellStyle tipStyle) {
        ...
        ...
        tipStyle.setWrapText(true);
        tipStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
        HSSFFont tipFont = workBook.createFont();
        tipFont.setFontHeightInPoints((short) 14);
        tipFont.setColor(HSSFColor.RED.index);
        tipStyle.setFont(tipFont);
}