x
Download x
Fillo-1.8.zip | Release Notes
Fillo-1.7.zip
Fillo-1.6.zip
     Email   
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.

Select

Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:\\Test.xlsx");
String strQuery="Select * from Sheet1 where ID=100";
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";

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();

Road Map

-Multiple Where Condition

Version

Fillo-1.8

Known Issues

-Multiple WHERE conditions are not supported

License

Apache License, Version 2.0

Email us, if you face any issues

support@codoid.com

Tags

Java Excel Query API, Excel API, Excel Query, Query Spreadsheet

     Email