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);