In the subsequent chapters, we will be dealing with a lot Excel data. In order to make data manipulation simpler using Excel, Codoid, a software firm, introduced the Fillo API. This API can be used for both XLS and XLSX files. It's an open source API. Fillo can be used to trigger select, insert, and update operations with where conditions. It also supports like and multiple where conditions. Let's understand how to make use of this useful API. First of all, let's add the Maven dependency for Fillo. Put the dependency shown here in pom.xml:
<dependency>
<groupId>com.codoid.products</groupId>
<artifactId>fillo</artifactId>
<version>1.18</version>
</dependency>
To start using Fillo in the code, create a class file in Eclipse and type the following code in a main method. This code first...