title: Apache POI: How to insert column in Excel file
body: <p>I'm using POI to manipulate data in Excel files for a university project. I'm having trouble inserting a new column in an existing Excel. I tried to use</p>
  
  <pre><code>Cell c = createCell(int column);
  c.setCellValue("someValue");
  </code></pre>
  
  <p>but it seems that if the column already exists, it replaces the existing data. What I need is to shift all the other columns one column to the right when I insert the new one.</p>
  
  <p>I searched over the internet but I couldn't find a solution to that. Is there a way to do it, without iterating all the cells in the row and moving them one-by-one ?</p>