strtob/yii2-excel-template-sql-export

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

dev-main 2024-11-26 15:32 UTC

Requires

• mootensai/yii2-enhanced-gii: dev-master
• phpoffice/phpspreadsheet: ^3.3

MIT

• Tobias Streckel

README

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 library to handle Excel file creation. Additionally, it provides a user-friendly graphical interface for managing SQL queries.

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.

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,
        ],