yidas / phpexcel-helper
Creating Excel with easy and artistic way based on PHPExcel
Installs: 2 457
Dependents: 0
Suggesters: 0
Security: 0
Stars: 2
Watchers: 2
Forks: 2
Open Issues: 0
Requires
- phpoffice/phpexcel: 1.*
README
Creating Excel with easy and artistic way based on PHPExcel
PHPExcel is no longer maintained and should not be used anymore.
You should migrate to this library's successor yidas/phpspreadsheet-helper.
OUTLINE
DEMONSTRATION
\PHPExcelHelper::newExcel() ->addRow(['ID', 'Name', 'Email']) ->addRows([ ['1', 'Nick','myintaer@gmail.com'], ['2', 'Eric','eric@.....'], ]) ->output('My Excel');
INSTALLATION
Run Composer in your project:
composer require yidas/phpexcel-helper
Then you could call it after Composer is loaded depended on your PHP framework:
require __DIR__ . '/vendor/autoload.php'; \PHPExcelHelper::newExcel();
USAGE
Merge Cells
\PHPExcelHelper::newExcel() ->addRows([ [['value'=>'SN', 'row'=>2], ['value'=>'Language', 'col'=>2], ['value'=>'Block', 'row'=>2, 'col'=>2]], ['','English','繁體中文',['skip'=>2]], ]) ->addRows([ ['1', 'Computer','電腦','#15'], ['2', 'Phone','手機','#4','#62'], ]) ->output('Merged Excel');
PHPExcel & Sheet Object
// Get a new PHPExcel object $objPHPExcel = new \PHPExcel; $objPHPExcel->getProperties() ->setCreator("Nick Tsai") ->setTitle("Office 2007 XLSX Document"); // Get the actived sheet object $objPHPExcelSheet = $objPHPExcel->setActiveSheetIndex(0); $objPHPExcelSheet->setTitle('Sheet'); $objPHPExcelSheet->setCellValue('A1', 'SN'); // Inject PHPExcel Object and Sheet Object to Helper \PHPExcelHelper::newExcel($objPHPExcel) ->setSheet($objPHPExcelSheet) ->setRowOffset(1) // Point to 1nd row from 0 ->addRows([ ['1'], ['2'], ]); \PHPExcelHelper::output();
\PHPExcelHelper::newExcel() ->setSheet(0, 'Sheet') ->addRow(['SN']); // Get the PHPExcel object created by Helper $objPHPExcel = \PHPExcelHelper::getExcel(); $objPHPExcel->getProperties() ->setCreator("Nick Tsai") ->setTitle("Office 2007 XLSX Document"); // Get the actived sheet object created by Helper $objPHPExcelSheet = \PHPExcelHelper::getSheet(); $objPHPExcelSheet->setCellValue('A2', '1'); $objPHPExcelSheet->setCellValue('A3', '2'); \PHPExcelHelper::output();
Multiple Sheets
\PHPExcelHelper::newExcel() ->setSheet(3, '4nd Sheet') ->addRow(['ID', 'Name']) ->addRows([ ['1', 'Nick'], ]); // Set another sheet object and switch to it \PHPExcelHelper::setSheet(1, '2nd Sheet') ->addRow(['SN', 'Title']) ->addRows([ ['1', 'Foo'], ]); \PHPExcelHelper::output('MultiSheets');
Map of Coordinates & Ranges
\PHPExcelHelper::newExcel() ->addRows([ [ ['value'=>'SN', 'row'=>2, 'key'=>'sn'], ['value'=>'Language', 'col'=>2, 'key'=>'lang'], ['value'=>'Block', 'row'=>2, 'col'=>2, 'key'=>'block'], ], [ '', ['value'=>'English', 'key'=>'lang-en'], ['value'=>'繁體中文', 'key'=>'lang-zh'], ['skip'=>2, 'key'=>'block-skip'], ], ]) ->addRows([ ['1', 'Computer','電腦','#15'], ['2', 'Phone','手機','#4','#62'], ]); // ->output('Merged Excel'); print_r(\PHPExcelHelper::getCoordinateMap()); print_r(\PHPExcelHelper::getRangeMap()); // print_r(\PHPExcelHelper::getColumnMap()); // print_r(\PHPExcelHelper::getRowMap()); echo "sn start cell: ". \PHPExcelHelper::getCoordinateMap('sn'); echo "\nsn start column: ". \PHPExcelHelper::getColumnMap('sn'); echo "\nsn start row: ". \PHPExcelHelper::getRowMap('sn'); echo "\nsn range: ". \PHPExcelHelper::getRangeMap('sn'); echo "\nAll range: ". \PHPExcelHelper::getRangeAll();
The result could be:
Array
(
[sn] => A1
[lang] => B1
[block] => D1
[lang-en] => B2
[lang-zh] => C2
[block-skip] => D2
)
Array
(
[sn] => A1:A2
[lang] => B1:C1
[block] => D1:E2
[lang-en] => B2:B2
[lang-zh] => C2:C2
[block-skip] => D2:E2
)
sn start cell: A1
sn start column: A
sn start row: 1
sn range: A1:A2
All range: A1:E4
Cells Format
- setWrapText(): Set to all cells by default
- setAutoSize(): Set to all cells(columns) by default
\PHPExcelHelper::newExcel() ->addRow(['Title', 'Content']) ->addRows([ ['Basic Plan', "*Interface\n*Search Tool"], ['Advanced Plan', "*Interface\n*Search Tool\n*Statistics"], ]) ->setWrapText() // ->setWrapText('B2') ->setAutoSize() // ->setAutoSize('B') ->output('Formatted Excel');