ApachePOI文本框与excel文本框看起来不同

Question

我想制作一个文本框，它看起来像上图中右边的那个。我尝试按照文档进行操作，并编写了以下代码。

public void TestXSSFPatriarch(String fileName, String richText) {
    Workbook workbook = new XSSFWorkbook();
    Sheet sheet = workbook.createSheet("hssf");
    XSSFDrawing xssfDrawing = (XSSFDrawing) sheet.createDrawingPatriarch();
    XSSFTextBox xssfTextBox = xssfDrawing.createTextbox(
            new XSSFClientAnchor(0, 0, 25, 50, (short) 0, 0, (short) 25, 50));
    xssfTextBox.setText(new XSSFRichTextString(richText));

    try (OutputStream fileOut = new FileOutputStream(fileName)) {
        workbook.write(fileOut);
        System.out.println("Success");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

上述代码输出上图左侧显示的文本框。在此方面的任何帮助都将不胜感激。

Answer 1

在尝试了XSSFTextBox提供的不同方法之后。我找到了一个名为setFillColor

public void TestXSSFPatriarch(String fileName, String richText) {
    Workbook workbook = new XSSFWorkbook();
    Sheet sheet = workbook.createSheet("hssf");
    XSSFDrawing xssfDrawing = (XSSFDrawing) sheet.createDrawingPatriarch();
    XSSFTextBox xssfTextBox = xssfDrawing.createTextbox(
            new XSSFClientAnchor(0, 0, 25, 50, (short) 0, 0, (short) 25, 50));
    xssfTextBox.setText(new XSSFRichTextString(richText));

    xssfTextBox.setFillColor(255, 255, 255); // Adding the following line solved the problem
    
    try (OutputStream fileOut = new FileOutputStream(fileName)) {
        workbook.write(fileOut);
        System.out.println("Success");
    } catch (IOException e) {
        e.printStackTrace();
    }
}