Skip to content

README.MD

Latest commit

 

History

History
146 lines (107 loc) · 4.05 KB

README.MD

File metadata and controls

146 lines (107 loc) · 4.05 KB

CODOID EXCEL

Fillo Examples

This repository demonstrates how to use Codoid's Fillo—an Excel API for Java—to read from and write to Excel files using SQL-like queries. The examples cover common operations such as SELECT, INSERT, and UPDATE on .xls and .xlsx files, with or without WHERE clauses.

📌 Why Use Fillo?

  • SQL Syntax: Fillo allows you to treat Excel sheets like database tables. Using simple SQL syntax. Use SELECT, UPDATE, and INSERT queries directly on Excel sheets.

  • No Coordinate Mapping: No need to track row[i] and column[j]. Just use column headers as field names.

  • Simplified Data-Driven Testing: Ideal for Selenium or API automation frameworks where test data is managed in Excel.

🗂️ Project Structure 

Fillo-Examples
├── src/
│   └── test/
│       └── java/
│           └── (example test classes using Fillo)
├── .gitignore
├── pom.xml
└── README.MD
  • src/test: Contains example Java/TestNG classes demonstrating Fillo usage
  • pom.xml: Maven configuration with Fillo and TestNG dependencies
  • README.MD: Project documentation

⚙️ Tech Stack

  • Java (JDK 8)
  • Maven for dependency management
  • Fillo (Excel API for Java)
  • TestNG for running example tests

📦 Maven Dependencies

The project uses the following key dependencies:

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

<dependency>
    <groupId>org.testng</groupId>
    <artifactId>testng</artifactId>
    <version>7.11.0</version>
</dependency>

💻 Code Examples

1. Fetching Data (SELECT)

Retrieve values from an Excel sheet where the sheet name is treated as the table name.

Fillo fillo = new Fillo();
Connection connection = fillo.getConnection("path/to/TestData.xlsx");
String strQuery = "Select * from Sheet1 where ID=101 and Status='Active'";
Recordset recordset = connection.executeQuery(strQuery);

while (recordset.next()) 
{
    System.out.println(recordset.getField("UserName"));
}
recordset.close();
connection.close();

2. Inserting Data (INSERT)

Add new rows to your Excel sheet effortlessly.

Connection connection = fillo.getConnection("path/to/TestData.xlsx");
String strQuery = "INSERT INTO Sheet1(Name, Country) VALUES('Gladson', 'India')";
connection.executeUpdate(strQuery);
connection.close();

3. Updating Data (UPDATE)

Update specific records using a WHERE clause.

Connection connection = fillo.getConnection("path/to/TestData.xlsx");
String strQuery = "UPDATE Sheet1 SET Status='Passed' where TestCaseID='TC_001'";
connection.executeUpdate(strQuery);
connection.close();

🚀 Getting Started

Prerequisites

  • Java JDK 8 or later

  • Apache Maven

  • An IDE such as IntelliJ IDEA or Eclipse Setup

  • Clone the repository:

    git clone https://github.com/GladsonAntony/Fillo-Examples.git
  • Import the project as a Maven project in your IDE. Let Maven download the required dependencies

✅ Use Cases

  • Data-driven testing using Excel as a lightweight data source
  • Test automation frameworks needing simple Excel CRUD operations
  • Proof-of-concept projects for Fillo integration

🤝 Contributing

Contributions are welcome! If you have improvements or additional examples:

  • Fork the repository
  • Create a feature branch
  • Commit your changes
  • Open a pull request

📄 License

This project is provided as an example for learning and experimentation purposes. Please refer to the Fillo library’s official license for usage terms.

👤 Author: GladsonAntony

⭐ If you find this repository useful, consider starring it on GitHub