Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created July 4, 2019 15:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/d2d9d17d977ab619c78961d0dbc8ac4c to your computer and use it in GitHub Desktop.
Save parzibyte/d2d9d17d977ab619c78961d0dbc8ac4c to your computer and use it in GitHub Desktop.
<?php
require __DIR__ . "/vendor/autoload.php";
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$documento = new Spreadsheet();
$documento
->getProperties()
->setCreator("Aquí va el creador, como cadena")
->setLastModifiedBy('Parzibyte') // última vez modificado por
->setTitle('Mi primer documento creado con PhpSpreadSheet')
->setSubject('El asunto')
->setDescription('Este documento fue generado para parzibyte.me')
->setKeywords('etiquetas o palabras clave separadas por espacios')
->setCategory('La categoría');
$hoja = $documento->getActiveSheet();
$hoja->setTitle("El título de la hoja");
$hoja->setCellValueByColumnAndRow(1, 1, "Un valor en 1, 1");
$hoja->setCellValue("B2", "Este va en B2");
$hoja->setCellValue("A3", "Parzibyte");
$writer = new Xlsx($documento);
# Le pasamos la ruta de guardado
$writer->save('ejemplo3.xlsx');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment