Differences

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

--- systems:yii2:yii_2.0_third_party_components [2018/01/09 14:48]
smayr [Mermaid JS support]
+++ 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 1677: / Line 1703: @@
 == 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]]