How to generate an .xlsx using php

by

SimpleXLSXGen

$books = [
    ['ISBN', 'title', 'author', 'publisher', 'ctry' ],
    [618260307, 'The Hobbit', 'J. R. R. Tolkien', 'Houghton Mifflin', 'USA'],
    [908606664, 'Slinky Malinki', 'Lynley Dodd', 'Mallinson Rendel', 'NZ']
];
$xlsx = Shuchkin\SimpleXLSXGen::fromArray( $books );
$xlsx->saveAs('books.xlsx');
//  $xlsx->downloadAs('books.xlsx');

More Related Contents:

  1. Export MySQL data to Excel in PHP
  2. PHPExcel — Color part of XLSX table
  3. phpexcel to download
  4. Easy way to export a SQL table without access to the server or phpMyADMIN
  5. How to generate an Excel document with multiple worksheets from PHP?
  6. Call to undefined method Maatwebsite\Excel\Excel::load()
  7. How to convert excel file into mysql database? [duplicate]
  8. Excel – Getting the Top 5 data of a column and their matching title but produces duplicates
  9. Which is the best way to generate excel output in PHP? [closed]
  10. What does \n mean [duplicate]
  11. I am new to php ,please tell me ,button click event should add new input tag to existing form through php [closed]
  12. Can I mix MySQL APIs in PHP?
  13. MySQL query to get column names?
  14. How to get protected property of object in PHP
  15. PHP cURL custom headers
  16. PHP & Case Sensitivity [duplicate]
  17. Insert/update helper function using PDO
  18. Calculating image size ratio for resizing
  19. .htaccess RewriteRule to preserve GET URL parameters
  20. Populate another select dropdown from database based on dropdown selection
  21. setcookie, Cannot modify header information – headers already sent [duplicate]
  22. Display float value w/o scientific notation
  23. PHP header location-redirect doesn’t work – why? [duplicate]
  24. Codeigniter Routes regex – using dashes in controller/method names
  25. How can I install zipArchive on PHP 7.2 with CentOS 7?
  26. make switch use === comparison not == comparison In PHP
  27. PHP GET Request, sending headers
  28. Removing last comma from a foreach loop
  29. Disable template caching for development in OpenCart 3
  30. Replacing invalid UTF-8 characters by question marks, mbstring.substitute_character seems ignored

Leave a Comment