title: Upload Excel file into database using Apache POI and Spring framework
body: <p>Couldn't find a good post on the internet to help me with this.</p>
  
  <p>My requirement is to read each row from a spreadsheet, and generate a sql statement with values from the cells and do a batch upload when reading the spreadsheet is done. </p>
  
  <p>I am using Apache POI, Spring framework and JDBC.</p>
  
  <p>How should i generate the sqls from excel?</p>
  
  <ol>
  <li>Have a sql statement with args (?) and format with the cell contents?</li>
  </ol>
  
  <p>or</p>
  
  <ol>
  <li>Prepare a sql by concatenating the cell contents?</li>
  </ol>
  
  <p>What's the best way to do this??</p>