PHP code example of moveek / excel-bundle
1. Go to this page and download the library: Download moveek/excel-bundle library . Choose the download type require .
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
moveek / excel-bundle example snippets
$writer = $this->get('phpspreadsheet')->createWriter($spreadsheet, 'Xls');
$writer->save('file.xls');
$writer = $this->get('phpspreadsheet')->createWriter($spreadsheet, 'Xlsx');
$response = $this->get('phpspreadsheet')->createStreamedResponse($writer);
$writer = $this->get('phpspreadsheet')->createSpreadSheet();
$writer->setActiveSheetIndex(0);
$activesheet = $writer->getActiveSheet();
$drawingobject = $this->get('phpspreadsheet')->createSpreadsheetWorksheetDrawing();
$drawingobject->setPath('/path/to/image')
->setName('Image name')
->setDescription('Image description')
->setHeight(60)
->setOffsetY(20)
->setCoordinates('A1')
->setWorksheet($activesheet);
$reader = $this->get('phpspreadsheet')->createReader('Xlsx');
php
$bundles = array(
// ...
new \Onurb\Bundle\ExcelBundle\OnurbExcelBundle(),
);
php
// config/bundles.php
return [
// ...
Onurb\Bundle\ExcelBundle\OnurbExcelBundle::class => ['all' => true],
];
php
$spreadsheet = $this->get('phpspreadsheet')->createSpreadsheet();
php
$spreadsheet = $this->get('phpspreadsheet')->createSpreadsheet('file.xlsx');