Re: Loading Data in separate class

Here's one way

public class JET2
{
  public static void main(String[] args)
  {
    processWorkbook(fetchWorkbook(args[0]));
  }

  public static void processWorkbook(Workbook workbook)
  {
    double stringa1 = 0;
    double stringa2 = 0;

    Sheet sheet1 = workbook.getSheet(0);
    Sheet sheet2 = workbook.getSheet(0);

    Cell a1 = sheet1.getCell(1, 1);
    Cell a2 = sheet2.getCell(0, 5);

    if (a1.getType() == CellType.NUMBER)
    {
      NumberCell fc1 = (NumberCell) a1;
      stringa1 = fc1.getValue();
    }
    if (a2.getType() == CellType.NUMBER)
    {
      NumberCell fc2 = (NumberCell) a2;
      stringa2 = fc2.getValue();
    }
    workbook.close();
  }

  public static Workbook fetchWorkbook(String fileName)
  {
    Workbook workbook = null;
    try
    {
      workbook = Workbook.getWorkbook(new File(fileName));
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    return workbook;
  }

}