Fillo: Query your excel

Recently I came across a really cool Java API called Fillo. It is an open-source API that lets you query Excel files (xls & xlsx) and it supports select, insert & update queries.

Maven dependency for Fillo: https://mvnrepository.com/artifact/com.codoid.products/fillo

My requirement is to fetch the APIs Name where Type=Regression and Run=Yes from below shown Excel table.

I have given a shot to simple queries and it works fine. Please check more details here: https://codoid.com/fillo/

P.S. I’m a strong believer in ‘we should use Public APIs instead of creating utilities from scratch’ unless we have some other restrictions like legal etc.

#testautomation #automationtesting #tipsandtricks #fillo #queryExcel

Fillo Execution