Java code to Auto size columns in Excel files created with Apache POI

 
This was the reports created by my java application and it turned out to be quite irritating as the columns are not auto sized.
 

 
The solution to the above problem is you just need to call a method to auto fit the column width.
Here is the code to auto size the first 5 columns of the spread sheet.
 

	HSSFSheet sheet = workBook.createSheet("testXls");
	 	 
	// Code to Auto size the column widths
	for(int columnPosition = 0; columnPosition< 5; columnPosition++) {
             sheet.autoSizeColumn((short) (columnPosition));
	}

Recommended reading:

• Java Code to Read XLS and XLSX Files
• Java code to convert xlsx & xls to csv

 
After using the above code the following output is obtained.