import java.io.FileInputStream;
import java.math.BigDecimal;
import java.sql.ResultSet;
import EasyXLS.*;

public class Tutorial31 {



  public static void main(String[] args) {
    try {
      System.out.println("Tutorial 31");
      System.out.println("----------");
      Double d1 = new Double("324324");
      BigDecimal bg = new BigDecimal(4353);
     
      //Create an instance of the object that generates Excel files
      ExcelDocument xls = new ExcelDocument();

      //Read the file
      System.out.println("Reading file C:\\temp\\BigNoHQ1.xls");
      FileInputStream file = new FileInputStream("C:\\temp\\BigNoHQ1.xls");
      ResultSet rs = xls.easy_ReadXLSSheet_AsResultSet(file, "Hierarchy-Goal");
      //Display the values
      int columnCount = rs.getMetaData().getColumnCount();
      int row = 0;
      while (rs.next()){
        for (int column=1; column<=columnCount; column++)
          System.out.println("At row " + (row + 1) + ", column " + (column) +
                             " the value is '" + rs.getBigDecimal((column)).toPlainString() + "'");
        row++;
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
}