title: How to set values from an excel sheet to Pojo object using apache-poi?
body: <p>I am trying to get values from an excel sheet using apache-poi and than to enter those values into a mysql database.Using apache-poi I am able to get values by using XSSFSheet.rowIterator() xssfrow.cellIterator();This excel sheet provides me 10000 rows and 180 columns.</p>
  
  <p>Now I want to to enter those excelsheet provided values to a table using hibernate framework  .so I have created a pojo in my java application which have 180 attributes in it ,So have 180  getters and 180 setters.</p>
  
  <p>Only way I can think setting these values to pojo attributes  is to iterate column iterator and then call setter method of pojo. I  am curious to know that can there be any smarter or more efficient way for doing it?</p>
  
  <p>Note : I  have tried to normalize table but as there is no  repetition of data so I don't think that table can be normalized</p>