XlsxCompiler

Takes a JSON in format:

{
    "Sheet name": [
        {"A": "A1 Value", "B": "B1 Value"}, // Row
        ...
    ],
    ...
    "Last sheet name": [
        {"A": "A1 Value", "B": "B1 Value"} // Row
    ],
    "maxCols": 2 // Max number of columns to be presented in the sheet
}

And transforms into a .xlsx file.

Usage

Install the package:

composer require websix/xlsx-compiler

Use the XlsxCompiler class in your script:

<?php

...
uses Websix\XlsxCompiler\XlsxCompiler;

...
$compiler = new XlsxCompiler();

// Generate $json in the shown format before

$xlsx = $compiler->compileJson($json);

// In $xlsx you have the fileblob tha you can save into a .xlsx file or echo in
// the output for browser download

API

Namespace: Websix\XlsxCompiler;

Class name: XlsxCompiler

#compileJson($json) -> blob

Pass in $json a JSON formatted as above and the result will be the xlsx blob