7interactive/php-office-helper

Helper package for handling creation of Office files

2.0.1 2022-01-24 00:22 UTC

Requires

• php: >=8.0
• nette/di: ^3.0
• nette/utils: ^3.2
• phpoffice/phpspreadsheet: ^1.21

MIT

• janondracek1

README

This package implements phpoffice/phpspreadsheet.

Usage

Implement new document class, extending BaseDocument or BaseExcelDocument, just like in example folder.

Implement new document helper class, which extends DocumentHelper and introduce a new method inside of it, just like below.

/**
 * Returns filename
 *
 * @param \DateTime $from
 * @param \DateTime $to
 * @return string
 */
public function createExcelSpreadsheetActivityLog(\DateTime $from, \DateTime $to): string
{
    /** @var ExampleSpreadsheet $document */
    $document = $this->documentFactory->createByClassName(ExampleSpreadsheet::class);
    $document->setRange($from, $to);
    return $this->documentFactory->save($document);
}

Installing

$ composer require 7interactive/php-office-helper

License

MIT