How to fit cell size

Question

I'm trying to build an excell file with apache. (HSSFWorkbook)

I cant figure out how to set column width size.

Look at the following example:

The first column (A) has the value: "row number" which we cant see the whole string. The columns (D) and (E) have the same problem, but If we double click on it we can see the full string.

I want to create cells which the user wouldn't need to double click on it. How can I do it ?

Answer 1

You can use autoSizecolumn() which will set column size based on its header.

sheet.autoSizeColumn(0)// to adjust first column

Please refer this link. It would be helpful...

To set all the available columns , use a for loop

for(int colNum = 0; colNum<row.getLastCellNum();colNum++)   
    workbook.getSheetAt(0).autoSizeColumn(colNum);

Answer 2

Try using the setColumnWidth() method on the HSSFSheet object

sheet.setColumnWidth(0, 1000);

This requires more code than using autoSizeColumn() but I have found that autoSizeColumn() can be ignored when opening the produced file in newer versions of Excel (2013).

Answer 3

Autofit will also work

(from the help file)
This example changes the width of columns A through I on Sheet1 to achieve the best fit.

Worksheets("Sheet1").Columns("A:I").AutoFit 

This example changes the width of columns A through E on Sheet1 to achieve the best fit, based only on the contents of cells A1:E1.

Worksheets("Sheet1").Range("A1:E1").Columns.AutoFit 

Answer 4

From the documentation:

Sheet sheet = workbook.getSheetAt(0);
sheet.autoSizeColumn(0); //adjust width of the first column
sheet.autoSizeColumn(1); //adjust width of the second column