dmoen/super-simple-excel

Package for creating a simple Excel file from arrays

Super simple excel

Simple package for creating an Excel file from arrays, traversable objects or Eloquent Collections when you dont need advanced configuration on cell level., _(*1)

Installation

This package can be installed via Composer:, _(*2)

``` bash composer require dmoen/super-simple-excel, <sub>(*3)</sub>

## Usage

Basic example

```php
$writer = ExcelWriter::create()
    ->setHeadings(["Lorem", "Ipsum", "Sit", "Amet"]);

$writer->addContent(["Row1", "Row1", "Row1", "Row1"]); 

$writer->addContent(["Row2", "Row2", "Row2", "Row2"])
    ->save("filepath");    

Also work with Eloquent Collections, <sub>(*4)</sub>

$writer = ExcelWriter::create()
    ->setHeadings(["Lorem", "Ipsum", "Sit", "Amet"]);
    ->addContent(App\User::all())
    ->save("filepath");    

If you want to output the file to the browser:, <sub>(*5)</sub>

$writer = ExcelWriter::create()
    ->setHeadings(["Lorem", "Ipsum", "Sit", "Amet"]);

$writer->addContent(["Row1", "Row1", "Row1", "Row1"]); 

$writer->addContent(["Row2", "Row2", "Row2", "Row2"])
    ->output("filename");    

Multi dimensional array, <sub>(*6)</sub>

ExcelWriter::create()
    ->setHeadings(["Lorem", "Ipsum", "Sit", "Amet"]);
    ->addContent([
        ["Row1", "Row1", "Row1", "Row1"],
        ["Row2", "Row2", "Row2", "Row2"]
    ])
    ->save("filepath");

Default styles can be set for font weight, font size, font type and alignment, <sub>(*7)</sub>

ExcelWriter::create(["bold" => true, "font" => "Arial", "size" => 20, "align" => "center"]);    

Styles can also be set for headings or specific row(s), <sub>(*8)</sub>

$writer = ExcelWriter::create();

$writer->setHeadings(
    ["Lorem", "Ipsum", "Sit", "Amet"],
    [
        "align" => "right",
        "bold"  => false,
        "size" => 15,
        "font" => "Arial"
    ]);

$writer->addContent(
    [
        ["Dolore", "Ipsum", "Amet", "Sit"],
        ["Dolore", "Ipsum", "Amet", "Sit"]
    ],
    [
        "align" => "right",
        "bold"  => false,
        "size" => 15,
        "font" => "Arial"
    ]
);

Sometimes you want some row spaces between the headings and the content rows:, <sub>(*9)</sub>

$writer = ExcelWriter::create();

$writer->setHeadings(
    ["Lorem", "Ipsum", "Sit", "Amet"], [], 1);