PHPackages ruhulfbr/excelq - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. ruhulfbr/excelq ActiveLibrary[Database & ORM](/categories/database) ruhulfbr/excelq =============== Make data retrieval query on Excel file like laravel `Query Builder` v1.0.1(2y ago)07MITPHPPHP ^8.0 Since May 10Pushed 2y ago1 watchersCompare [ Source](https://github.com/ruhulfbr/excelq)[ Packagist](https://packagist.org/packages/ruhulfbr/excelq)[ RSS](/packages/ruhulfbr-excelq/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (2)Dependencies (2)Versions (3)Used By (0) Query on Excel ============== [](#query-on-excel) **Query on Excel** allows you to perform queries on Excel. NOTE ---- [](#note) - Supported Extensions: Please use `.xls` or `.xlsx`. - Please ensure Excel data is well-formatted. Follow `example.xls`, and `example.xlsx`. Use Cases --------- [](#use-cases) This package is suitable for you if you need to perform some queries on: - Perform SELECT query - Perform where query (where, orWhere, whereIn, whereNotIn e.t.c) - Perform Sorting - Perform Limit, Offset - Perform Aggregate Query (count, sum, avg, max, min) Installation ------------ [](#installation) To install the package, you can use [Composer](https://getcomposer.org/): ``` composer require ruhulfbr/excelq ``` Basic Usage ----------- [](#basic-usage) To instantiate the EXLQ do the following: ``` require_once 'vendor/autoload.php'; use Ruhul\EXLQuery\EXLQ; try { $result = EXLQ::from("example.xls") ->select('id', 'name') ->get(); } catch (\Exception $e) { $result = $e->getMessage(); } pr($result); ``` Querying, sorting and get results --------------------------------- [](#querying-sorting-and-get-results) You can perform queries on your Excel: ``` $result = EXLQ::from("example.xls") ->select('id', 'name') //->select(['id', 'name']) ->where('id', 2) //->where('id', '>' ,2) ->orWhere('id', 3) //->orWhere('id', '>=', 3) ->whereLike('name', 'ruhul') //->whereLike('name', 'ruhul', 'start') //->whereLike('name', 'ruhul', 'end') ->whereIn('age', [22,23,25,26]) ->whereNotIn('age', [11,12,13]) ->orderBy('id') //->orderBy('id', 'desc') //->orderBy('id', 'asc') //->latest('id') // Default Id //->oldest('id') // Default Id ->get(); ``` ### More Example [](#more-example) ``` // To Get All Result $result = EXLQ::from("example.xls")->all(); // To Get All Sorted Result $result = EXLQ::from("example.xls")->orderBy('id', 'desc')->all(); // To Get Specific Row $result = EXLQ::from("example.xls")->where('id', 1)->row(); // To Get First Result $result = EXLQ::from("example.xls")->where('id', 1)->first(); // To Get Last Result $result = EXLQ::from("example.xls")->where('id', 1)->last(); // To Get nth row $result = EXLQ::from("example.xls")->getNth(2); // [0-n] // Check Is row exist $result = EXLQ::from("example.xls")->where('id', 1)->hasData(); // boolean $result = EXLQ::from("example.xls")->where('id', 1)->doesExist(); // boolean // To Get All Sorted Result $result = EXLQ::from("example.xls")->orderBy('id', 'desc')->all(); ``` ### Available where operators [](#available-where-operators) - `=` (default operator, can be omitted) - `>` - `select('*') ->orderBy('id') ->limit(10) //->limit(10, 2) ->get(); ``` Aggregator Query ---------------- [](#aggregator-query) You can add criteria and specify limit and offset for your query results: ``` // To Get Count $result = EXLQ::from("example.xls")->count(); // To Get Sum $result = EXLQ::from("example.xls")->sum('age'); // To Get Average $result = EXLQ::from("example.xls")->avg('age'); // To Get row with minimum column value $result = EXLQ::from("example.xls")->min('age'); // To Get row with maximum column value $result = EXLQ::from("example.xls")->max('age'); ``` Support ------- [](#support) If you found an issue or had an idea please refer [to this section](https://github.com/ruhulfbr/excelq/issues). Authors ------- [](#authors) - **Md Ruhul Amin** - [Github](https://github.com/ruhulfbr) ### Health Score 21 — LowBetter than 19% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity4 Limited adoption so far Community7 Small or concentrated contributor base Maturity47 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 2 Last Release 732d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/9600ba7b93d10623dc0519cd11fd5063d3770c06c29f7b54533ac316cbd334a1?d=identicon)[ruhulfbr](/maintainers/ruhulfbr) --- Top Contributors [![ruhulfbr](https://avatars.githubusercontent.com/u/25591435?v=4)](https://github.com/ruhulfbr "ruhulfbr (8 commits)") --- Tags phpjsoncomposerarraypackagedatasqlexcelxlsxlsxconversionqueryphp8jsonqrowarrayqExcel on QueryExcel QueryExcelqexcelqry ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/ruhulfbr-excelq/health.svg) ``` [![Health](https://phpackages.com/badges/ruhulfbr-excelq/health.svg)](https://phpackages.com/packages/ruhulfbr-excelq) ``` ### Alternatives [annexare/countries-list Continents & countries: ISO 3166-1 alpha-2 code, name, ISO 639-1 languages, capital, currency, native name, phone. JSON, CSV and SQL. 1.3k220.8k1](/packages/annexare-countries-list)[butschster/dbml-parser DBML (database markup language) parser written on PHP8. 6416.8k2](/packages/butschster-dbml-parser)[lekoala/spread-compat Easily manipulate PhpSpreadsheet, OpenSpout and League CSV 1216.3k1](/packages/lekoala-spread-compat) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)