PHPackages ptrnov/yii2-postman4excel - 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. [PDF & Document Generation](/categories/documents) 4. / 5. ptrnov/yii2-postman4excel ActiveYii2-extension[PDF & Document Generation](/categories/documents) ptrnov/yii2-postman4excel ========================= Excel on view or console cronjobs 2.4.7(9y ago)286[2 issues](https://github.com/ptrnov/yii2-postman4excel/issues)BSD-3-ClausePHP Since Jul 24Pushed 9y ago1 watchersCompare [ Source](https://github.com/ptrnov/yii2-postman4excel)[ Packagist](https://packagist.org/packages/ptrnov/yii2-postman4excel)[ RSS](/packages/ptrnov-yii2-postman4excel/feed)WikiDiscussions master Synced 4w ago READMEChangelog (10)Dependencies (2)Versions (13)Used By (0) Postman Excel for Yii 2 ======================= [](#postman-excel-for-yii-2) Base On scotthuangzl (ptrnov update) Postman Excel Export for view or console cronjobs, mail postman Installation ------------ [](#installation) The preferred way to install this extension is through [composer](http://getcomposer.org/download/). Either run ``` php composer.phar require --prefer-dist ptrnov/yii2-postman4excel "*" ``` or add ``` "ptrnov/yii2-postman4excel": "*" ``` to the require section of your `composer.json` file. Usage ----- [](#usage) Once the extension is installed, simply use it in your code by : ``` use ptrnov\postman4excel\Postman4ExcelBehavior; public function behaviors(){ 'export4excel' => [ 'class' => Postman4ExcelBehavior::className(), 'downloadPath'=>'your path' //defult "/vendor/ptrnov/yii2-postman4excel/tmp/", Ecample Windows path "d:/folder/" 'widgetType'=>'download' //download web browser, delete before download, tmp_download //'widgetType'=>'cronjob' //console method, folder tmp_cronjob //'widgetType'=>'mail' //posman mail, folder tmp_mail //'widgetType'=>'' //Empty same download, file stay on folder "tmp_mix" //'prefixStr' => yii::$app->user->identity->username, //'suffixStr' => date('Ymd-His'), ], } // localhost/yourController/test-export public function actionTestExport() { //get data from database $sqlDataProvider= new ArrayDataProvider([ 'allModels'=>\Yii::$app->db->createCommand(" SELECT id, username FROM user ")->queryAll(), ]); $arySqlDataProvider=$sqlDataProvider->allModels; /*Array Model Data*/ $excel_dataAll = Postman4ExcelBehavior::excelDataFormat($arySqlDataProvider); (not used for columnGroup just put 'ceils' => $arySqlDataProvider) $excel_ceilsAll = $excel_dataAll['excel_ceils']; $excel_title1 = $excel_dataAll['excel_title']; $excel_title2 = ['ID','USERNAME']; //Tite Header From Table Name //$excel_title = $excel_dataAll['excel_title']; //Tite Header From Modify byself //$excel_title = ['ID','USERNAME'] //Note 'sheet_title' //old version : 'sheet_title' => $excel_title, //new Version : 'sheet_title' => [$excel_title1,$excel_title2,$excel_title3, dst], $excel_content = [ [ 'sheet_name' => 'TEST EXPORT 1 old version', 'sheet_title' => $excel_title1, //old version 'ceils' => $excel_ceilsAll,// atau langsung $arySqlDataProvider; //for use column Group. //noted: 'ceils' => "Array Source", not need difinition "Postman4ExcelBehavior::excelDataFormat($array source);" //'columnGroup'=>Name of Field//column group difinition. 'columnGroup'=>['ID'],//column for grouping. 'autoSize'=>true, //true/false. //'freezePane' => 'A2', 'headerColor' => Postman4ExcelBehavior::getCssClass("header"), //All Header Color font and Backgroud 'headerColumnCssClass' => [ //old version [ 'id' => Postman4ExcelBehavior::getCssClass('yellow'), 'username' => Postman4ExcelBehavior::getCssClass('green'), ], [ 'ID' => Postman4ExcelBehavior::getCssClass('red'), 'USERNAME' => Postman4ExcelBehavior::getCssClass('green'), ] ], 'oddCssClass' => Postman4ExcelBehavior::getCssClass("odd"), 'evenCssClass' => Postman4ExcelBehavior::getCssClass("even"), ], [ 'sheet_name' => 'TEST EXPORT 2 new version ', //'sheet_title' => [$excel_title1], //new version | one Header 'sheet_title' => [ //new version | two or more Header $excel_title1, $excel_title2 ], //new version 'ceils' => $excel_ceilsAll, //'freezePane' => 'E2', 'headerColor' => Postman4ExcelBehavior::getCssClass("header"), //old Version | All Header Color font and Backgroud /* -------------------------------------------------------- * customize Header properties * Color Ref: http://dmcritchie.mvps.org/excel/colors.htm * columnAutoSize=false, width is Active * 'merge'=>'col,row' * Content properties, validate on use last column title * -------------------------------------------------------- */ 'headerStyle' => [ //new version [ //the first Header 'id' => ['align'=>'CENTER','color-font'=>'0000FF','color-background'=>'FFCCCC','merge'=>'0,2','width'=>'2,0'], 'username' => ['align'=>'left','color-font'=>'FF0000','color-background'=>'CCFF99','merge'=>'2,1','width'=>'32.29','valign'=>'center','wrap'=>true], ], [ //The second Header 'ID' => ['align'=>'right','color-font'=>'0000FF','color-background'=>'CCFFCC'], 'USERNAME' => ['align'=>'right','color-font'=>'000000','color-background'=>'FFFF99'], ] ], 'contentStyle' => [ //new version [//the first Content //'id' => ['align'=>'left'], //'username' => ['align'=>'right'], ], [//The second Content 'ID' => ['align'=>'center','color-font'=>'0000FF'], 'USERNAME' => ['align'=>'center','color-font'=>'0000FF'], ], ], 'oddCssClass' => Postman4ExcelBehavior::getCssClass("odd"), 'evenCssClass' => Postman4ExcelBehavior::getCssClass("even"), ], ]; $excelFile = "TestExport"; $this->export4excel($excel_content, $excelFile); } ``` ### Health Score 26 — LowBetter than 41% of packages Maintenance0 Infrequent updates — may be unmaintained Popularity12 Limited adoption so far Community7 Small or concentrated contributor base Maturity70 Established project with proven stability 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 ~26 days Recently: every ~65 days Total 12 Last Release 3343d ago Major Versions v1.0.0 → 2.0.02016-08-09 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/11422990?v=4)[Piter Novian](/maintainers/ptrnov)[@ptrnov](https://github.com/ptrnov) --- Top Contributors [![ptrnov](https://avatars.githubusercontent.com/u/11422990?v=4)](https://github.com/ptrnov "ptrnov (5 commits)") --- Tags excelyii2extensionPostmanptrnovpostman4excelpostman4 ### Embed Badge ![Health badge](/badges/ptrnov-yii2-postman4excel/health.svg) ``` [![Health](https://phpackages.com/badges/ptrnov-yii2-postman4excel/health.svg)](https://phpackages.com/packages/ptrnov-yii2-postman4excel) ``` ### Alternatives [moonlandsoft/yii2-phpexcel Exporting PHP to Excel or Importing Excel to PHP 1381.1M16](/packages/moonlandsoft-yii2-phpexcel)[arogachev/yii2-excel ActiveRecord import and export based on PHPExcel for Yii 2 framework 6381.0k1](/packages/arogachev-yii2-excel)[phpnt/yii2-export Yii2 It saves data in xls, csv, word, html, pdf files. 158.9k](/packages/phpnt-yii2-export)[custom-it/yii2-excel-report An extension for generate excel file from GridView content 371.9k](/packages/custom-it-yii2-excel-report) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)