Download the PHP package oncology-support/phpspreadsheet-helper-bundle without Composer
On this page you can find all versions of the php package oncology-support/phpspreadsheet-helper-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download oncology-support/phpspreadsheet-helper-bundle
More information about oncology-support/phpspreadsheet-helper-bundle
Files in oncology-support/phpspreadsheet-helper-bundle
Package phpspreadsheet-helper-bundle
Short Description Symfony Bundle
License MIT
Homepage https://github.com/ehymel/PhpSpreadsheetHelperBundle
Informations about the package phpspreadsheet-helper-bundle
PhpSpreadsheet Helper Bundle
PhpSpreadsheet Helper Bundle
eases the use of the excellent
PHPOffice/PhpSpreadsheet
in your Symfony application by adding helper methods
Documentation
What's new in version 2
WorksheetFactory has been re-factored to WorksheetUtils to allow the helper methods to be available on worksheets beyond the first tab of the spreadsheet. See the example below.
License
PhpSpreadsheet Helper Bundle is released under the MIT License. See the bundled LICENSE file for details.
Installation
Applications that use Symfony Flex
Open a command console, enter your project directory and execute:
Applications that don't use Symfony Flex
Step 1: Download the Bundle
Open a command console, enter your project directory and execute the following command to download the latest stable version of this bundle:
Step 2: Enable the Bundle
Then, enable the bundle by adding it to the list of registered bundles
in the config/bundles.php
file of your project:
Step 3: Use it!
This bundle provides helper functions that you call from your controller.
// your controller
use OncologySupport\PhpSpreadsheetHelper\Utilities\SpreadsheetFactory;
use OncologySupport\PhpSpreadsheetHelper\Utilities\WorksheetUtils;
public function createAndDownloadSpreadsheet()
{
$spreadsheet = new SpreadsheetFactory();
$worksheet = new WorksheetUtils($spreadsheet->getActiveSheet(), 'First Tab');
$worksheet->addTitleRow('Very Important Data');
$header = ['Order Date', 'Site', 'Item', 'Item Description'];
$rows = [
['12/15/2023', 'Main site', 'Dog collar', 'A stunning red dog collar'],
['12/19/2023', 'Main site', 'Cat collar', 'Blue cat collar'],
['1/3/2024', 'Backup site', 'Turtle harness', 'Take your turtle for a walk!'],
];
$worksheet->addDataRows[$rows];
// add another tab on the spreadsheet
$worksheet2 = new WorksheetUtils($spreadsheet->createSheet(), 'Second Tab');
$spreadsheet->setActiveSheetIndex(1);
$worksheet2->addTitleRow('Even More Important Data');
$header = ['Order Date', 'Site', 'Item', 'Item Description'];
$rows = [
['2/12/2024', 'Main site', 'Donkey collar', 'Big enough for the most stubborn donk'],
['4/3/2024', 'Backup site', 'Duck harness', 'Take your duck for a walk!'],
];
$worksheet2->addDataRows[$rows];
// download to an excel file
$spreadsheet->outputToWeb();
}
Enjoy!
All versions of phpspreadsheet-helper-bundle with dependencies
phpoffice/phpspreadsheet Version ^3.3
symfony/config Version ^6.0 || ^7.0
symfony/dependency-injection Version ^6.0 || ^7.0
symfony/http-kernel Version ^6.0 || ^7.0
symfony/flex Version ^2.4
symfony/yaml Version ^6.0 || ^7.0