Skip to content

77web/Nanaweb.ExcelSelectionSetter

master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
src
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Build Status

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.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages