Apache POI Excel - how to configure columns to be expanded?
Solution 1:
After you have added all your data to the sheet, you can call autoSizeColumn(int column) on your sheet to autofit the columns to the proper size
Here is a link to the API.
See this post for more reference Problem in fitting the excel cell size to the size of the content when using apache poi
Solution 2:
Tip : To make Auto size work , the call to sheet.autoSizeColumn(columnNumber) should be made after populating the data into the excel.
Calling the method before populating the data, will have no effect.