Differences

This shows you the differences between two versions of the page.

--- systems:yii2:yii_2.0_third_party_components [2017/11/17 09:28]
smayr [Barcoding (yii2-barcode-generator)]
+++ systems:yii2:yii_2.0_third_party_components [2018/02/05 14:42] (current)
smayr [PHPOffice/PhpSpreadsheet]
@@ Line 944: / Line 944: @@
 </code>
-== yii2-phpexcel PhpExcel ==
+== yii2-phpexcel PhpExcel (Deprecated: use PHPOffice/PhpSpreadsheet) ==
 Get documentation from:
   * [[https://github.com/moonlandsoft/yii2-phpexcel]]
@@ Line 953: / Line 953: @@
 </code>
+== PHPOffice/PhpSpreadsheet ==
+Get documentation from:
+  * [[https://github.com/PHPOffice/PhpSpreadsheet]]
+  * [[https://phpspreadsheet.readthedocs.io/en/develop|Documentation]]
+Install the extension:
+<code bash>
+$ composer require phpoffice/phpspreadsheet
+</code>
+Example:
+<code php>
+<?php
+require 'vendor/autoload.php';
+use PhpOffice\PhpSpreadsheet\Spreadsheet;
+use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
+$spreadsheet = new Spreadsheet();
+$sheet = $spreadsheet->getActiveSheet();
+$sheet->setCellValue('A1', 'Hello World !');
+$writer = new Xlsx($spreadsheet);
+$writer->save('hello world.xlsx');
+</code>
 == DatePicker ==
   * run in your project dir: <code>
@@ Line 1663: / Line 1689: @@
 }
 </code>
+Add ''mermaid'' code to a view.  Eg: Flowchart sample:
+<code php>
+<div class='mermaid'>
+graph TD;
+    A-->B;
+    A-->C;
+    B-->D;
+    C-->D;
+</div>
+</code>
+== Yii2 Shopping Cart ==
+  * [[https://github.com/omnilight/yii2-shopping-cart|Yii2 Shopping Cart]]
+  * [[https://stackoverflow.com/questions/29443226/yii2-trouble-with-using-shopping-cart-extension]]