nanaweb/excel-selection-setter

v1.0.3 2017-07-03 01:48 UTC

Requires

• nanaweb/excel-util: ~0.9.1

Requires (Dev)

• phpunit/phpunit: ^4.8

MIT

README

Nanaweb.ExcelSelectionSetter

Sets active sheet and active cells of xlsx files.

Installation

Use composer.

$ composer require nanaweb/excel-selection-setter

Usage

AllFirst

Select first cell in each sheet, first sheet of the workbook.

<?php

use Nanaweb\ExcelSelectionSetter\ExcelSelectionSetter;
use Nanaweb\ExcelSelectionSetter\Strategy\AllFirst;


$setter = new ExcelSelectionSetter();
$setter->addStrategy(new AllFirst());

$setter->execute($pathToYourXlsx, 'all_first');

SynchronizeToTemplate

Select the sheet which is selected in the template, cells which are selected in the template.

<?php

use Nanaweb\ExcelSelectionSetter\ExcelSelectionSetter;
use Nanaweb\ExcelSelectionSetter\Strategy\SynchronizeToTemplate;


$setter = new ExcelSelectionSetter();
$setter->addStrategy(new SynchronizeToTemplate());

$setter->execute($pathToYourXlsx, 'synchronize_to_template');

Create your own strategy

Any classes which implement StrategyInterface are accepted as strategy.