Skip to content

php-etl/spreadsheet-plugin

Repository files navigation

Spreadsheet Plugin

Mutations PHPUnit Quality PHPStan level 5 PHPStan level 6 PHPStan level 7 PHPStan level 8 PHP

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