PHP code example of dmoen / super-simple-excel

1. Go to this page and download the library: Download dmoen/super-simple-excel library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

dmoen / super-simple-excel example snippets


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

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

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

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

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

ExcelWriter::create()
    ->setHeadings(["Lorem", "Ipsum", "Sit", "Amet"]);
    ->addContent([
        ["Row1", "Row1", "Row1", "Row1"],
        ["Row2", "Row2", "Row2", "Row2"]
    ])
    ->save("filepath");
  
ExcelWriter::create(["bold" => true, "font" => "Arial", "size" => 20, "align" => "center"]);    

$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"
    ]
);

$writer = ExcelWriter::create();

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