bur-gmbh/xlsx2data

There is no license information available for the latest version (dev-master) of this package.

dev-master 2019-04-05 12:34 UTC

Requires

• cocur/slugify: ^3.2
• phpoffice/phpspreadsheet: ^1.6
• symfony/yaml: ^4.2

Unknown License

• Tobias Redmann

README

PHP Library to convert Microsoft Excel files to xml, yaml or json data

Installation

The most convenient way to use the converter is with composer

composer require bur-gmbh/xlsx2data

Usage

To load an Microsoft Excel file just use the constructor and pass the filepath and name of the worksheet:

$file = 'myExcel.xlsx';
$sheet = 'Worksheet';

$converter = new Converter($file, $sheet);

If you don't pass a worksheet name the converter will use the active worksheet.

XML

To convert the Excel data to XMl use the toXml function.

$converter->toXml();

You can also save the data directly using:

$converter->saveXml('output.xml');

JSON

To convert the Excel data to JSON use the following toJson function.

$converter->toJson()

Save Json:

$converter->saveJson('output.json');

YAML

Get the Excel data as Yaml with the toYaml command.

$converter->toYaml()

Save as Yaml

$converter->saveYaml('output.yaml');