authenticode / spreadsheet
Replace a worksheet within an Excel workbook (.xlsx) without changing any other properties of the file. Works best with pivot tables
Requires
- php: >=5.3.0
Requires (Dev)
- mikey179/vfsstream: 1.3.*@dev
- phpspec/phpspec: ~2.0
This package is auto-updated.
Last update: 2021-07-15 14:16:04 UTC
README
Replace a worksheet within an Excel workbook (.xlsx) without changing any other properties of the file.
License
This program is free software; see LICENSE for more details.
Details
The main purpose of this library is adding a "data table" to an existing excel file without modifing any other components. This is especially useful if you have a template file, e.g. for reporting including "advanced" features like charts, pivot tables, macros and you'd like to change a base data table within a PHP application.
Setup
Use composer to add this repository to your dependencies:
{ "require": { "authenticode/spreadsheet": "dev-master" } }
Examples
The following example demonstrates how to use Spreadsheet. The following is also
contained as example.php
within the folder "examples/":
<?php require_once('../vendor/autoload.php'); // Create a new instance $dataTable = new Authenticode\Spreadsheet\Spreadsheet(); // Specify the source file $in = 'spec.xlsx'; // Specify the output file $out = 'test.xlsx'; // Specify the data for the worksheet. $data = array( array("Date" => new \DateTime('2014-01-01 13:00:00'), "Value 1" => 0, "Value 2" => 1), array("Date" => new \DateTime('2014-01-02 14:00:00'), "Value 1" => 1, "Value 2" => 0), array("Date" => new \DateTime('2014-01-03 15:00:00'), "Value 1" => 2, "Value 2" => -1), array("Date" => new \DateTime('2014-01-04 16:00:00'), "Value 1" => 3, "Value 2" => -2), array("Date" => new \DateTime('2014-01-05 17:00:00'), "Value 1" => 4, "Value 2" => -3), ); // Attach the data table and copy the new xlsx file to the output file. $dataTable->showHeaders()->addRows($data)->attachToFile($in, $out); ?>
In this example the method "attachToFile" creates a new excel file. If you use this library within a web application you might prefer the "fillXLSX()" function which returns a string representation of the excel document. The following examples demonstrates this case within a laravel application
<?php class ReportController extends Controller { protected $dataTable; public function __construct(\Authenticode\Spreadsheet\Spreadsheet $dataTable) { $this->dataTable = $dataTable; } public function show($month) { $data = DB::select('select date,value1,value2 from reporting where MONTH(date) = ?', array($month)); $path = storage_path() . '/reports/example.xlsx'; $xlsx = $this->dataTable->showHeaders()->addRows($data)->fillXLSX($path); return Response::make($xlsx, 200, array( 'Content-Type' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'Content-Disposition' => 'attachment; filename="report.xlsx"', 'Content-Length' => strlen($xlsx) )); // ... } } ?>
Suggestions?
Create an issue!