title: Fillo Implementation
body: <p>I came across a really nice and simple xls and xlsx implementation API called Fillo. I've made a spread sheet with the following values as most people know the all caps sections are for category names to seac</p>
  
  <pre><code>USERID    PASS
  joe       bigjoe
  jim       bigjim
  john      bigjohn
  </code></pre>
  
  <p>Now here's the code:</p>
  
  <pre><code>    import Exception.FilloException;
      import Fillo.*;
  
  
    public class CallBack {
      public static void main(String args[]) throws FilloException {
          testFillo();
      }
  
      private static void testFillo() throws FilloException {
          Fillo fillo=new Fillo();
          Connection connection=fillo.getConnection("logindatabase.xls");
          String strQuery="Select * from Sheet1 where USERID='*' and PASS='*'";
          Recordset recordset=connection.executeQuery(strQuery);
  
          /*
           * I'm wanting the login check to be right here
           */
  
          recordset.close();
          connection.close();
  
      }
  }
  </code></pre>
  
  <p>The login function should go through the USERID column first and once it finds that it will check the corresponding PASS value. So if it found "jim" as the user it then check for "bigjim" as the password.</p>
  
  <p>So the big question would be: How would I set something like this up? </p>
  
  <p>Here's the <a href="http://www.codoid.com/products/view/2/29" rel="nofollow">Fillo Documentation</a>.</p>
  
  <p>All the best,</p>
  
  <p>Groax</p>