PHPackages                             strtob/yii2-excel-template-sql-export - 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. [File & Storage](/categories/file-storage)
4. /
5. strtob/yii2-excel-template-sql-export

ActiveYii2-extension[File & Storage](/categories/file-storage)

strtob/yii2-excel-template-sql-export
=====================================

Yii2 module to manage sql commands, which can be export in one MS Excel worksheet

10PHP

Since Nov 26Pushed 1y ago1 watchersCompare

[ Source](https://github.com/strtob/yii2-excel-template-sql-export)[ Packagist](https://packagist.org/packages/strtob/yii2-excel-template-sql-export)[ RSS](/packages/strtob-yii2-excel-template-sql-export/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Yii2 Excel Template SQL Export Module
=====================================

[](#yii2-excel-template-sql-export-module)

Overview
--------

[](#overview)

The **Yii2 Excel Template SQL Export** module allows you to export the results of raw SQL queries directly into an Excel file. This module is built on the Yii2 framework and leverages the [PhpSpreadsheet](https://phpspreadsheet.readthedocs.io/) library to handle Excel file creation. Additionally, it provides a user-friendly graphical interface for managing SQL queries.

Features
--------

[](#features)

- Export multiple SQL queries into a single Excel file.
- Dynamic worksheet creation based on SQL query results.
- Option to filter exported queries using specific IDs.
- Exception handling for graceful error responses.
- GUI for easy management of SQL queries, including adding, editing, and deleting queries.

[![](https://github.com/strtob/yii2-excel-template-sql-export/raw/main/Screenshot.png)](https://github.com/strtob/yii2-excel-template-sql-export/blob/main/Screenshot.png)

Installation
------------

[](#installation)

To install this module, follow these steps:

**Add the module to your project**: Use Composer to install the module. Run the following command in your terminal:

```
   composer require strtob/yii2-excel-template-sql-export
```

create the tables via migration

```
php yii migrate --migrationPath=@vendor/strtob/yii2-excel-template-sql-export/migrations
php yii migrate
```

or

```
'components' => [
    // Other components...
    'migrator' => [
        'class' => 'yii\db\Migration',
        'migrationPath' => [
            '@vendor/strtob/yii2-excel-template-sql-export/migrations', // Add your module's migrations
        ],
    ],
],
```

and adjust your config

```
 'modules' => [
        'export' => [
            'class' => \strtob\yii2ExcelTemplateSqlExport\Module::class,
        ],
```

###  Health Score

14

—

LowBetter than 2% of packages

Maintenance30

Infrequent updates — may be unmaintained

Popularity2

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity16

Early-stage or recently created project

 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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/1cca3f4cf786146ef62da60fc8a21f94943c7da6d7cbfb453b3e1389390c8d2a?d=identicon)[strtob](/maintainers/strtob)

---

Top Contributors

[![strtob](https://avatars.githubusercontent.com/u/9219549?v=4)](https://github.com/strtob "strtob (6 commits)")

### Embed Badge

![Health badge](/badges/strtob-yii2-excel-template-sql-export/health.svg)

```
[![Health](https://phpackages.com/badges/strtob-yii2-excel-template-sql-export/health.svg)](https://phpackages.com/packages/strtob-yii2-excel-template-sql-export)
```

###  Alternatives

[knplabs/gaufrette

PHP library that provides a filesystem abstraction layer

2.5k39.8M123](/packages/knplabs-gaufrette)[superbalist/flysystem-google-storage

Flysystem adapter for Google Cloud Storage

26320.6M30](/packages/superbalist-flysystem-google-storage)[illuminate/filesystem

The Illuminate Filesystem package.

15161.6M2.6k](/packages/illuminate-filesystem)[creocoder/yii2-flysystem

The flysystem extension for the Yii framework

2931.7M62](/packages/creocoder-yii2-flysystem)[flowjs/flow-php-server

PHP library for handling chunk uploads. Works with flow.js html5 file uploads.

2451.6M15](/packages/flowjs-flow-php-server)[madnest/madzipper

Easier zip file handling for Laravel applications.

1382.3M6](/packages/madnest-madzipper)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)