title: reading multiple excel sheets in java
body: <p>I am trying to add values of multiple sheets of an Excel document to an ArrayList. without using HSSFSheet. this seems more simple think.Be careful dont forget to change string type to numeric.                                 </p>
  
  <pre><code>public void setinputfile(String inputfile) {
      this.inputfile = inputfile;}
  
  public void read() throws IOException {
      File inputWorkbook = new File(inputfile);
  
      try {
          Workbook w = Workbook.getWorkbook(inputWorkbook);
          int Num = w.getNumberOfSheets();
          for (int i = 0; i &lt; Num; i++) {
              Sheet sheet = w.getSheet(i);
              Sheet s = w.getSheet(i);
              int row = s.getRows();
              int col = s.getColumns();
              for (int i1 = 0; i1 &lt; row; i1++) {
                  inner = new ArrayList&lt;Double&gt;();
                  for (int j = 0; j &lt; col; j++) {
                      Cell c = s.getCell(j, i1);
                      CellType type = c.getType();
                      System.out.println(c.getContents());
                      String text = c.getContents(); // example String
                      double value = Double.parseDouble(text);
                      inner.add(value);
                  }
                  Kargo_Amount.add(inner);
              }
  
          }
      } catch (BiffException e) {
          e.printStackTrace();
      }
  }
  public static void main(String[] args) throws Exception {
      Facility_Location test = new Facility_Location();
      test.setinputfile("C:\\Users\\soheyl\\Desktop\\Kargo miktarii.xls");
      test.read();
  }
  </code></pre>