title: store data from excel in list after reading with java
body: <p>i am using APACHE POI to read the data from excel files. I would like to store them in lists (like list in c) the result because afterwards I will try to store them in mysql database calling only list[0], list[1] for example. What i will try to do is make this list and after i will use jdbc driver and giving this list to make the tables in mysql.
  The code for reading excel file is the above:</p>
  
  <pre><code>import java.io.FileInputStream;
  import java.io.IOException;
  import java.util.ArrayList;
  import java.util.Iterator;
  import java.util.List;
  
  import org.apache.poi.hssf.usermodel.HSSFCell;
  import org.apache.poi.hssf.usermodel.HSSFRow;
  import org.apache.poi.hssf.usermodel.HSSFSheet;
  import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  import org.apache.poi.ss.usermodel.Cell;
  
  public class readexcel{
  </code></pre>
  
  <p>@SuppressWarnings({ "unchecked", "unchecked" })
  public static void main(String[] args) throws Exception {</p>
  
  <pre><code>//
   // An excel file name. You can create a file name with a full
   // path information.
   //
  String filename = "C:\\Users\\xxx\\Documents\\test.xls";
  
  //
  // Create an ArrayList to store the data read from excel sheet.
  //
  List sheetData = new ArrayList();
  FileInputStream fis = null;
  try {
  //
  // Create a FileInputStream that will be use to read the
  // excel file.
  //
  fis = new FileInputStream(filename);
  
   //
   // Create an excel workbook from the file system.
  //
  HSSFWorkbook workbook = new HSSFWorkbook(fis);
  //
  // Get the first sheet on the workbook.
  //
  HSSFSheet sheet = workbook.getSheetAt(0);
  
   //
    // When we have a sheet object in hand we can iterator on
  // each sheet's rows and on each row's cells. We store the
  // data read on an ArrayList so that we can printed the
  // content of the excel to the console.
   //
  Iterator rows = sheet.rowIterator();
  while (rows.hasNext()) {
  HSSFRow row = (HSSFRow) rows.next();
  Iterator cells = row.cellIterator();
  
  List data = new ArrayList();
  while (cells.hasNext()) {
  HSSFCell cell = (HSSFCell) cells.next();
  data.add(cell);
   }
  
  sheetData.add(data);
   }
   } catch (IOException e) {
  e.printStackTrace();
   } finally { 
   if (fis != null) {
   fis.close();
   }
   }
  
   showExcelData(sheetData);
    }
  
   private static void showExcelData(List sheetData) {
    //
      // Iterates the data and print it out to the console.
    //
  for (int i = 0; i &lt; sheetData.size(); i++) {
   List list = (List) sheetData.get(i);
  for (int j = 0; j &lt; list.size(); j++) {
  Cell cell = (Cell) list.get(j);
  if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
  System.out.print(cell.getNumericCellValue());
  } else if (cell.getCellType() == Cell.CELL_TYPE_STRING) {
  System.out.print(cell.getRichStringCellValue());
  } else if (cell.getCellType() == Cell.CELL_TYPE_BOOLEAN) {
  System.out.print(cell.getBooleanCellValue());
  }
  if (j &lt; list.size() - 1) {
  System.out.print(", ");
  }
  }
  System.out.println("");
  }
  }
  }
  </code></pre>
  
  <p>What i have to add to do what i explain you?</p>