PHP code example of tacoberu / nette-response-spreadsheet
1. Go to this page and download the library: Download tacoberu/nette-response-spreadsheet 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/ */
tacoberu / nette-response-spreadsheet example snippets
use Taco\Nette\Application\Responses;
class SomePresenter extends BasePresenter
{
function actionDefault()
{
$data = [
[ 'George', 'age' => 15, 'grade' => 2, ],
[ 'Jack', 'age' => 17, 'grade' => 4, ],
[ 'name' => 'Mary', 'age' => 17, 'grade' => 1, ],
];
$response = new Responses\SpreadsheetResponse($data);
$this->sendResponse( $response );
}
}
use Taco\Nette\Application\Responses;
class SomePresenter extends BasePresenter
{
function actionDefault()
{
$headers = [ 'Name', 'Age', 'Grade'];
$data = [
[ 'George', 15, 2, ],
[ 'Jack', 17, 4, ],
[ 'Mary', 17, 1, ],
];
$response = new Responses\SpreadsheetResponse($data, $headers);
$this->sendResponse( $response );
}
}
use Taco\Nette\Application\Responses;
class SomePresenter extends BasePresenter
{
function actionDefault()
{
$headers = [ 'Name', 'Age', 'Grade'];
$data = [
[ 'George', 15, 2, ],
[ 'Jack', 17, 4, ],
[ 'Mary', 17, 1, ],
];
$response = new Responses\SpreadsheetResponse($data, $headers);
$response
->setFilename('export')
->setTitle('Export');
$this->sendResponse( $response );
}
}
use Taco\Nette\Application\Responses;
class SomePresenter extends BasePresenter
{
function actionDefault()
{
$headers1 = [ 'Name', 'Age', 'Grade'];
$data1 = [
[ 'George', 15, 2, ],
[ 'Jack', 17, 4, ],
[ 'Mary', 17, 1, ],
];
$headers2 = [ 'City', 'Population'];
$data2 = [
[ 'Prague', 1.257, ],
[ 'Paris', 2.211, ],
[ 'London', 8.308, ],
];
$response = new Responses\SpreadsheetResponse($data1, $headers1);
$response
->setFilename('export')
->setTitle('Export');
->addSheet($data2, $headers2);
$this->sendResponse( $response );
}
}