自动换行apache POI（Excel）

I have a java program which takes header and data as the input and produces an excel file.

我有一个java程序，它将标题和数据作为输入并生成一个excel文件。

However, sometimes when the header values are long and the number of columns are more, my excel sheet tends to be unnecessarily wide.

但是，有时当标题值很长并且列数更多时，我的Excel工作表往往会不必要地变宽。

Because of the headers, I will have to scroll down to right to see the content of the tail end columns.

由于标题，我将向下滚动到右边以查看尾端列的内容。

Is there a way I can resolve this such that if the content in the cell is bigger then say value x, then auto wrap occurrs and automatically the row height gets adjusted and the column width gets fixed.

有没有办法可以解决这个问题，如果单元格中的内容比较大，然后说值x，则自动换行并自动调整行高度并修改列宽。

The rough algorithm for what I am looking for is:

我正在寻找的粗略算法是：

 if(content.size is more then 50 chars){
       - apply auto wrap with centred text
       - adjust the row height accordingly
       - adjust all the cells in the column accordingly
 }

If someone could point me to some example available online.

如果有人能指出我在网上提供的一些例子。

Thanks for reading!

谢谢阅读！

1 个解决方案

#1

You should be able to achieve this with a Cell style, I have tried to put together an example to show:

你应该能够用Cell风格实现这一点，我试图将一个例子放在一起展示：

public class SO{
    public static void main(String[] args) {

        try {
            FileInputStream is = new FileInputStream(new File("D:\\Users\\user2777005\\Desktop\\bob.xlsx"));
            XSSFWorkbook wb = new XSSFWorkbook(is);
            String header = "123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789";
            Sheet sheet = wb.getSheet("Sheet1");
            sheet.setColumnWidth(0, 18000);
            Row row = sheet.createRow(0);
            Cell cell = row.createCell(0);

            if(header.length() > 50){ //Length of String for my test
                sheet.setColumnWidth(0, 18000); //Set column width, you'll probably want to tweak the second int
                CellStyle style = wb.createCellStyle(); //Create new style
                style.setWrapText(true); //Set wordwrap
                cell.setCellStyle(style); //Apply style to cell
                cell.setCellValue(header); //Write header
            }

            wb.write(new FileOutputStream(new File("D:\\Users\\user2777005\\Desktop\\bob.xlsx")));
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

Good Luck!

祝你好运！

#1