title: JAVA+POI API Excel- Need to increase width of the column
body: <p>I want to increase the width of the column of excel sheet. as the i am writing trough code is long.
  and I need to drag the column manually to see the full text.</p>
  
  <p>I did this –</p>
  
  <pre><code>HSSFRow dataRow = sampleDataSheet.createRow(0);
  
  HSSFCellStyle cellStyle = setHeaderStyle(sampleWorkbook);
  
  cellStyle.setWrapText(true);
  
  ***sampleDataSheet.autoSizeColumn(1000000);***
  </code></pre>
  
  <p>But its not changing anything..</p>