Fillo


Fillo is an Excel API for Java and you can query xls & xlsx files. Now, it supports SELECT, UPDATE & INSERT queries with or without WHERE clause. You can also find a list of a list of previous releases and release notes.

Maven Dependency

Select

Update

Insert

Multiple Where conditions

Where method

LIKE Operator

Set table starting row and column

Version

Fillo-1.16

License

Apache License, Version 2.0

Email us, if you face any issues

[email protected]

Download Fillo

Please fill out the form below to download Fillo.

41 thoughts on “Fillo

    1. Please try as below.

      Fillo fillo=new Fillo();

      Connection connection = fillo.getConnection(“C:\\Workbook.xlsx”);

      connection.createTable(“Table Name”,new String[]{“Column_1″,”Column_2”});

    1. Hello Siva,

      Try this.

      Recordset recordset=connection.executeQuery(“Select * From Sheet1”);

      while(recordset.next()){

      for (String strColumn:recordset.getFieldNames()) {
      System.out.println(“==================>”+strColumn);
      System.out.println(recordset.getField(strColumn));
      }

      }

  1. how can I get the first item of a returned column ??
    if recordset.getField(“Data1Column”)
    returns
    1
    2
    3
    how can i select only 1 of these values

    1. Hello Mohamed,

      Try as below,

      Recordset recordset=connection.executeQuery(“Select * From Sheet1”);

      //To get First Column Value from first row in recordset
      recordset.next();
      System.out.println(recordset.getField(0).value());

      //To get First Column Value from second row
      recordset.next();
      System.out.println(recordset.getField(0).value());

  2. Hi,

    My Query is String

    strQuery=”Select * from \””+l_sheetname+”\” where \””+l_scenarioname+”\” ”” ;
    strQuery=”Select * from \””+l_sheetname+”\” where \””+l_scenarioname+”\” is not NULL ;

    This query does not skips the cell with empty data. How do i skip the cells with empty data in that column..

  3. Hi, I would like to know how to get access from on a server share? “\\\\server\\share\\file.xlsx” as file string doesn’t work for me. Is there a possibility to connect file as unc path?
    Thanks in advance
    Bernd

  4. Hi, I would like to know how to access excel files on a share? The following example throw me an exception: Workbook not found.
    Is there a possibility to access file as unc path?

    Thanks and Regards

    Fillo fillo = new Fillo();
    try {
    Connection connection=fillo.getConnection(“\\\\server\\share\\file.xlsx”);
    String strQuery = “Select * from Sheet1”;
    Recordset recordset = connection.executeQuery(strQuery);

    while (recordset.next()) {
    System.out.println(recordset.getField(“USERID”));
    }

    recordset.close();
    connection.close();
    } catch (FilloException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

  5. hi there are 4 excell sheet in one folder , can we create connection dynamically? for example some stage i need data from one excel sheet and another stage from another excel sheet

  6. Fillo fillo = new Fillo();
    Connection connection=fillo.getConnection(“TestData/trial.xlsx”);
    Recordset recordset=connection.executeQuery(“Select * from Sheet1”);

    I am getting java.lang.NoSuchFieldError, could you explain me how to deal with this ??

    1. I am also facing the same problem. Full error message
      Exception in thread “main” java.lang.NoSuchFieldError: RETURN_BLANK_AS_NULL
      at com.codoid.products.fillo.CommonExcelUtil.getColumnNames(CommonExcelUtil.java:78)
      at com.codoid.products.fillo.SelectExcelUtil.runSelectQuery(SelectExcelUtil.java:84)
      at com.codoid.products.fillo.Select.getRecordset(Select.java:61)
      at com.codoid.products.fillo.Connection.executeQuery(Connection.java:56)
      at testJavaCode.excelUsingFillo.main(excelUsingFillo.java:22)

      1. Hi Mahesh,

        We are not able to reproduce the issue.

        It would be great if you send a sample excel sheet which you have used to reproduce the issue.

        Thanks

        1. Hi Admin ,
          I have the same problem
          java.lang.NoSuchFieldError: RETURN_BLANK_AS_NULL
          at com.codoid.products.fillo.CommonExcelUtil.getColumnNames(CommonExcelUtil.java:78)
          at com.codoid.products.fillo.SelectExcelUtil.runSelectQuery(SelectExcelUtil.java:84)
          at com.codoid.products.fillo.Select.getRecordset(Select.java:61)
          at com.codoid.products.fillo.Connection.executeQuery(Connection.java:56)
          at testmain.XLSReader.getTests(XLSReader.java:26)
          my query is : “Select * from Sheet1 where Active = ‘Y’ and Module = ‘Login'”

  7. I have a problem to delete a row with more than a condition, I tried only with one condition was well, but when I put add other conditions , no row was deleted. My query is that:

    String sql = “DELETE FROM Sheet1 WHERE column1 =’Operativo’ and column2=’Meter reseteando'”
    I would want to delete only to have this two condition

  8. Hi all,

    Could it be possible to obtain the Connection connection=fillo.getConnection(path_to_file) from a byte array? I would like to read from an in-memory Excel file.

    Thanks.

  9. Another question please: Is UPPER, LOWER supported in queries? Something like this: Select * from MyTable where upper(Schedule) = upper(‘M02W2D1T1800’)

    Thank you.

  10. Getting Exception in thread “main” java.lang.NoSuchFieldError: RETURN_BLANK_AS_NULL

    plese find the below code:
    Exception in thread “main” java.lang.NoSuchFieldError: RETURN_BLANK_AS_NULL

    I am using Fillo 1.10 jar and xls file

    please help me to resolve this issue.

Leave a Reply

Your email address will not be published. Required fields are marked *