title: How to read values from excel file and store in Array?
body: <p>I want to read excel sheet values and store those values in an array in Java.</p>
  
  <p>I have code ready to read excel sheet but i am not able to customize it to store those values in Array.</p>
  
  <p>Here is my code to read an excel sheet : </p>
  
  <pre><code>package com.core.testscripts;
  
  import java.io.File;
  import java.io.IOException;
  
  import jxl.Cell;
  import jxl.Sheet;
  import jxl.Workbook;
  import jxl.read.biff.BiffException;
  
  public class NewExcel 
  {
  
      private String inputFile;
  
      public void setInputFile(String inputFile) 
      {
          this.inputFile = inputFile;
      }
  
      public void read() throws IOException  
      {
          File inputWorkbook = new File(inputFile);
          Workbook w;
          try 
          {
              w = Workbook.getWorkbook(inputWorkbook);
              // Get the first sheet
              Sheet sheet = w.getSheet(0);
              // Loop over first 10 column and lines
  
              for (int j = 0; j &lt; sheet.getColumns(); j++) 
              {
                  for (int i = 0; i &lt; sheet.getRows(); i++) 
                  {
                      Cell cell = sheet.getCell(j, i);
                      System.out.println(cell.getContents());
                  }
              }
          } 
          catch (BiffException e) 
          {
              e.printStackTrace();
          }
      }
  
      public static void main(String[] args) throws IOException 
      {
          NewExcel test = new NewExcel();
          test.setInputFile("D:/hellohowareyou.xls");
          test.read();
      }
  
  }
  </code></pre>