Fillo

Java Excel Library

Data Manipulation Tool
Freeware
Supports XLSX & XLS

Release Notes

Release Date: September 19, 2016

Please enter details to download

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

<dependency>
  <groupId>com.codoid.products</groupId>
  <artifactId>fillo</artifactId>
  <version>1.23</version>
</dependency>

Select

Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:Test.xlsx");
String strQuery="Select * from Sheet1 where ID=100 and name='John'";
Recordset recordset=connection.executeQuery(strQuery);

while(recordset.next()){
System.out.println(recordset.getField("Details"));
}

recordset.close();
connection.close();

Update

Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:Test.xlsx");
String strQuery="Update Sheet1 Set Country='US' where ID=100 and name='John'";

connection.executeUpdate(strQuery);

connection.close();

Insert

Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:Test.xlsx");
String strQuery="INSERT INTO sheet4(Name,Country) VALUES('Peter','UK')";

connection.executeUpdate(strQuery);

connection.close();

Multiple Where conditions

//This is an enhancement in Fillo-1.11, now you can mention multiple conditions in a query as shown below.
Recordset recordset=connection.executeQuery("Select * from Sheet1 where column1=value1 and column2=value2 and column3=value3");

Where method

Recordset recordset=connection.executeQuery("Select * from Sheet1").where("ID=100").where("name='John'");

LIKE Operator

Recordset recordset=connection.executeQuery("Select * from Sheet1 where Name like 'Cod%'");

Distinct:

Recordset recordset = connection.executeQuery("SELECT DISTINCT ColumnName FROM SheetName");
while (recordset.next()) {
    System.out.println(recordset.getField("ColumnName"));
}

Set table starting row and column

//Now you can set table start row and column
System.setProperty("ROW", "5");//Table start row
System.setProperty("COLUMN", "3");//Table start column
Fillo fillo=new Fillo();
Connection connection=fillo.getConnection(strFile);

Email us, if you face any issues

[email protected]

Please enter details to download

Written By

admin

Posted on September 19, 2016

Submit a Comment Cancel reply

Comments(1)

zoritoler imol
Posted on Mar 08, 2025

3 months ago

hello there and thank you for your information – I have definitely picked up something new from right here. I did however expertise some technical points using this site, since I experienced to reload the site a lot of times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I am complaining, but sluggish loading instances times will sometimes affect your placement in google and can damage your high quality score if advertising and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and could look out for a lot more of your respective intriguing content. Ensure that you update this again soon..