php-etl/spreadsheet-plugin

Plugin for XLS Extractor and Loader

v0.5.2 2023-04-20 09:21 UTC

Requires

• php: ^8.2
• nikic/php-parser: ^4.10
• php-etl/configurator-contracts: 0.8.*
• php-etl/packaging-contracts: 0.3.*
• php-etl/satellite-toolbox: *
• symfony/config: ^6.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.0
• infection/infection: ^0.26.18
• php-etl/bucket-contracts: 0.2.*
• php-etl/phpunit-extension: *
• php-etl/pipeline-contracts: 0.4.*
• php-etl/spreadsheet-flow: *
• phpstan/phpstan: ^1.10
• phpunit/phpunit: ^10.0
• rector/rector: ^0.15
• symfony/yaml: ^6.0

MIT

• Grégory Planchat

README

This package aims at integrating the Spreadsheet or the Opendocument reader and writer into the Pipeline stack.

Principles

The tools in this library will produce executable PHP sources, using an intermediate Abstract Syntax Tree from nikic/php-parser. This intermediate format helps you combine the code produced by this library with other packages from Middleware.

Installation

composer require php-etl/spreadsheet-plugin

Usage

Example of a config file. Reads input.xlsx, writes output.xlsx, logs error in system's stderr.

spreadsheet:
    extractor:
      file_path: 'input.xlsx'
      excel:
        sheet: 'sheet2'
        skip_line: 1
#  loader:
#    file_path: 'output.xlsx'
#    excel:
#      sheet: 'sheet2'
    logger:
        type: stderr