PHP Classes

Simple PHP XLSX Generator: Export data in Excel XLSX format

Recommend this page to a friend!
  Info   View files Documentation   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2020-05-19 (6 days ago) RSS 2.0 feedNot yet rated by the usersTotal: 188 This week: 188All time: 8,402 This week: 1Up
Version License PHP version Categories
simplexlsxgen 0.9.10MIT/X Consortium ...5XML, Files and Folders
Description Author

This package can export data in Excel XLSX format.

It can take an array of data with the definition of the values that will fill a spreadsheet and exports that spreadsheet definition to MicroSoft Excel XLS format.

The generated spreadsheet can be saved to a file with a given file name or be served for download via the current Web browser.

  Performance   Level  
Name: Sergey Shuchkin <contact>
Classes: 4 packages by
Country: Russian Federation Russian Federation
Age: 38
All time rank: 653 in Russian Federation Russian Federation
Week rank: 1 Up
Innovation award
Innovation award
Nominee: 1x

 

Details

SimpleXLSXGen class 0.9.10 (Official)

<img src="https://img.shields.io/endpoint.svg?url=https%3A%2F%2Fshieldsio-patreon.herokuapp.com%2Fshuchkin" /> <img src="https://img.shields.io/github/license/shuchkin/simplexlsxgen" /> <img src="https://img.shields.io/github/stars/shuchkin/simplexlsxgen" /> <img src="https://img.shields.io/github/forks/shuchkin/simplexlsxgen" /> <img src="https://img.shields.io/github/issues/shuchkin/simplexlsxgen" />

Export data to Excel XLSX file. PHP XLSX generator. No external tools and libraries.<br/> (!) XLSX reader here.

Sergey Shuchkin <sergey.shuchkin@gmail.com> 2020<br/>

Hey, bro, please ? the package for my motivation :)

Basic Usage

$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 = SimpleXLSXGen::fromArray( $books );
$xlsx->saveAs('books.xlsx');

XLSX screenshot

// SimpleXLSXGen::download() or SimpleXSLSXGen::downloadAs('table.xlsx');

Installation

The recommended way to install this library is through Composer. New to Composer?

This will install the latest supported version:

$ composer require shuchkin/simplexlsxgen

or download class here

Examples

Data types

$data = [
    ['Integer', 123],
    ['Float', 12.35],
    ['Procent', '12%'],
    ['Date','2020-05-20'],
    ['Datetime', '2020-05-20 02:38:00'],
    ['String', 'See SimpleXLSXGen column autosize feature']
];
SimpleXLSXGen::fromArray( $data )->saveAs('datatypes.xlsx');

XLSX screenshot

History

v0.9.10 (2020-05-20) initial relese

Screenshots  
  • datatypes.png
  • books.png
  Files folder image Files  
File Role Description
Files folder imagesrc (1 file)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file composer.lock Data Auxiliary data
Accessible without login Plain text file license.md Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  src  
File Role Description
  Plain text file SimpleXLSXGen.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:188
This week:188
All time:8,402
This week:1Up

For more information send a message to info at phpclasses dot org.