Home>Programming related>Other source code
Download
simplexlsxgen

SimpleXLSXGen

Export data to Excel XLSX file. PHP XLSX generator. No external tools and libraries.

  • XLSX reader here
  • XLS reader here
  • CSV reader/writer here

Sergey Shuchkin [email protected] 2020-2024

Hey, bro, please ★ the package for my motivation :) and donate for more 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 = ShuchkinSimpleXLSXGen::fromArray( $books );
$xlsx->saveAs('books.xlsx'); // or downloadAs('books.xlsx') or $xlsx_content = (string) $xlsx

XLSX screenshot

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

Use UTF-8 encoded strings.

Data types

500'], ['Currency Float (other)', ''], ['Datetime', '2020-05-20 02:38:00'], ['Date', '2020-05-20'], ['Time', '02:38:00'], ['Datetime PHP', new DateTime('2021-02-06 21:07:00')], ['String', 'Very long UTF-8 string in autoresized column'], ['Formula', 'SUM(B1:B2)'], ['Hyperlink', 'https://github.com/shuchkin/simplexlsxgen'], ['Hyperlink + Anchor', 'SimpleXLSXGen'], ['Internal link', 'Go to second page'], ['RAW string', "" . '2020-10-04 16:02:00'], ['Formatted RAW string', '2024-07-28 16:02:00'], ]; SimpleXLSXGen::fromArray($data)->saveAs('datatypes.xlsx');">
$data = [
    ['Integer', 123],
    ['Float', 12.35],
    ['Percent', '12%'],
    ['Currency $', '$500.67'],
    ['Currency €', '200 €'],
    ['Currency ₽', '1200.30 ₽'],
    ['Currency (other)', ''],
    ['Currency Float (other)', ''],
    ['Datetime', '2020-05-20 02:38:00'],
    ['Date', '2020-05-20'],
    ['Time', '02:38:00'],
    ['Datetime PHP', new DateTime('2021-02-06 21:07:00')],
    ['String', 'Very long UTF-8 string in autoresized column'],
    ['Formula', 'SUM(B1:B2)'],
    ['Hyperlink', 'https://github.com/shuchkin/simplexlsxgen'],
    ['Hyperlink + Anchor', 'SimpleXLSXGen'],
    ['Internal link', 'Go to second page'],
    ['RAW string', "" . '2020-10-04 16:02:00'],
    ['Formatted RAW string', '2024-07-28 16:02:00'],
];
SimpleXLSXGen::fromArray($data)->saveAs('datatypes.xlsx');

XLSX screenshot

Formatting

SimpleXLSXGen'], ['Green', ''], ['Bold Red Text', ''], ['Size 32 Font', ''], ['Blue Text and Yellow Fill', ''], ['Border color', ''], ['Border style',''], ['Border sides', ''], ['Left', '12345.67'], ['Center', '
12345.67
'], ['Right', 'Right Text'], ['Center + Bold', '
Name
'], ['Row height', ''], ['Top', ''], ['Middle + Center', ''], ['Bottom + Right', ''], ['
MERGE CELLS MERGE CELLS MERGE CELLS MERGE CELLS MERGE CELLS
', null], ['Word wrap', "Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book"], ['Linebreaks', "Line 1nLine 2nLine 3"] ]; SimpleXLSXGen::fromArray($data) ->setDefaultFont('Courier New') ->setDefaultFontSize(14) ->setColWidth(1, 35) ->mergeCells('A20:B20') ->saveAs('styles_and_tags.xlsx');">
$data = [
    ['Normal', '12345.67'],
    ['Bold', '12345.67'],
    ['Italic', '12345.67'],
    ['Underline', '12345.67'],
    ['Strike', '12345.67'],
    ['Bold + Italic', '12345.67'],
    ['Hyperlink', 'https://github.com/shuchkin/simplexlsxgen'],
    ['Italic + Hyperlink + Anchor', 'SimpleXLSXGen'],
    ['Green', ''],
    ['Bold Red Text', ''],
    ['Size 32 Font', ''],
    ['Blue Text and Yellow Fill', ''],
    ['Border color', ''],
    ['Border style',''],
    ['Border sides', ''],
    ['Left', '12345.67'],
    ['Center', '
12345.67
'],
    ['Right', 'Right Text'],
    ['Center + Bold', '
Name
'],
    ['Row height', ''],
    ['Top', ''],
    ['Middle + Center', ''],
    ['Bottom + Right', ''],
    ['
MERGE CELLS MERGE CELLS MERGE CELLS MERGE CELLS MERGE CELLS
', null],
    ['Word wrap', "Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book"],
    ['Linebreaks', "Line 1nLine 2nLine 3"]
];
SimpleXLSXGen::fromArray($data)
    ->setDefaultFont('Courier New')
    ->setDefaultFontSize(14)
    ->setColWidth(1, 35)
    ->mergeCells('A20:B20')
    ->saveAs('styles_and_tags.xlsx');

XLSX screenshot

RAW Strings

Prefix #0 cell value (use double quotes) or use ::raw() method, or tag

+123456 <tag>
'], ]; SimpleXLSXGen::fromArray($data) ->saveAs('test_rawstrings.xlsx');">
$PushkinDOB = '1799-07-06';
$data = [
    ['Datetime as raw string', "".'2023-01-09 11:16:34'],
    ['Date as raw string', "".$PushkinDOB],
    ['Disable type detection', "".'+12345'],
    ['Insert greater/less them simbols', SimpleXLSXGen::raw('20- short term: <6 month')],
    ['Formatted raw', '
+123456 <tag>
'],
];
SimpleXLSXGen::fromArray($data)
    ->saveAs('test_rawstrings.xlsx');

More examples

Go to second sheet'], ['http', 'https://example.com/'], // autodetect ['http + hash', 'https://en.wikipedia.org/wiki/Office_Open_XML#References'], // autodetect ['external anchor', 'Open XML'], ['relative link', 'books'], ['relative link + cell addr', 'link to second sheet in other book'], ['mailto', '[email protected]'], // autodetect ['mailto 2', 'Please email me'], ])->addSheet([['Second sheet']], 'My books 2')->saveAs('hyperlinks.xlsx'); // Autofilter $xlsx->autoFilter('A1:B10'); // Freeze rows and columns from top-left corner up to, but not including, // the row and column of the indicated cell $xlsx->freezePanes('B2'); // B1 - freeze first column, A2 - freeze top row // RTL mode // Column A is on the far right, Column B is one column left of Column A, and so on. // Also, information in cells is displayed in the Right to Left format. $xlsx->rightToLeft(); // Set Meta Data Files // this data in propertis Files and Info file in Office $xlsx->setAuthor('John Doe ') ->setCompany('JD LLC ') ->setManager('Jane Doe ') ->setLastModifiedBy("John Doe ") ->setTitle('My Books') ->setSubject('My bookshelf') ->setKeywords('Tolkien,Rowling,Kipling') ->setDescription('Cool books worn by time') ->setCategory('Books') ->setLanguage('en-US') ->setApplication('ShuchkinSimpleXLSXGen')">
// Fluid interface, output to browser for download
ShuchkinSimpleXLSXGen::fromArray( $books )->downloadAs('table.xlsx');

// Fluid interface, multiple sheets
ShuchkinSimpleXLSXGen::fromArray( $books, 'My books' )->addSheet( $books2 )->download();

// Alternative interface, sheet name, get xlsx content
$xlsx_cache = (string) (new ShuchkinSimpleXLSXGen)->addSheet( $books, 'Modern style');

// Classic interface
use ShuchkinSimpleXLSXGen;
$xlsx = new SimpleXLSXGen();
$xlsx->addSheet( $books, 'Catalog 2021' );
$xlsx->addSheet( $books2, 'Stephen King catalog');
$xlsx->downloadAs('books_2021.xlsx');
exit();

// Empty book with title
$xlsx = SimpleXLSX::create('My books');
$xlsx->addSheet( $books );
$xlsx->save(); // ./My books.xlsx

// Hyperlinks
$xlsx = SimpleXLSX::fromArray([
    ['internal link', 'My books 2'!A1">Go to second sheet'],
    ['http', 'https://example.com/'], // autodetect
    ['http + hash', 'https://en.wikipedia.org/wiki/Office_Open_XML#References'], // autodetect
    ['external anchor', 'Open XML'],
    ['relative link', 'books'],
    ['relative link + cell addr', 'Sheet 2'!A1">link to second sheet in other book'],
    ['mailto', '[email protected]'], // autodetect
    ['mailto 2', 'Please email me'],
])->addSheet([['Second sheet']], 'My books 2')->saveAs('hyperlinks.xlsx');

// Autofilter
$xlsx->autoFilter('A1:B10');

// Freeze rows and columns from top-left corner up to, but not including,
// the row and column of the indicated cell
$xlsx->freezePanes('B2'); // B1 - freeze first column, A2 - freeze top row

// RTL mode
// Column A is on the far right, Column B is one column left of Column A, and so on.
// Also, information in cells is displayed in the Right to Left format.
$xlsx->rightToLeft();

// Set Meta Data Files
// this data in propertis Files and Info file in Office 
$xlsx->setAuthor('John Doe ')
    ->setCompany('JD LLC ')
    ->setManager('Jane Doe ')
    ->setLastModifiedBy("John Doe ")
    ->setTitle('My Books')
    ->setSubject('My bookshelf')
    ->setKeywords('Tolkien,Rowling,Kipling')
    ->setDescription('Cool books worn by time')
    ->setCategory('Books')
    ->setLanguage('en-US')
    ->setApplication('ShuchkinSimpleXLSXGen')

JS array to Excel (AJAX)

JS array to Excel ">
 // array2excel.php
if (isset($_POST['array2excel'])) {
    require __DIR__.'/simplexlsxgen/src/SimpleXLSXGen.php';
    $data = json_decode($_POST['array2excel'], false);
    ShuchkinSimpleXLSXGen::fromArray($data)->downloadAs('file.xlsx');
    return;
}
?>


    JS array to Excel

Debug

ini_set('error_reporting', E_ALL );
ini_set('display_errors', 1 );

$data = [
    ['Debug', 123]
];

ShuchkinSimpleXLSXGen::fromArray( $data )->saveAs('debug.xlsx');
Expand
Additional Information
Related Applications
Recommended for You
Related Information All
User Comments