Download the PHP package bcostea/excelerate without Composer
On this page you can find all versions of the php package bcostea/excelerate. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download bcostea/excelerate
More information about bcostea/excelerate
Files in bcostea/excelerate
Download bcostea/excelerate
More information about bcostea/excelerate
Files in bcostea/excelerate
Vendor bcostea
Package excelerate
Short Description PHP Library to write and read XLSX files
License MIT
Homepage https://github.com/bcostea/Excelerate
Package excelerate
Short Description PHP Library to write and read XLSX files
License MIT
Homepage https://github.com/bcostea/Excelerate
Please rate this library. Is it a good library?
Informations about the package excelerate
Excelerate
Description
This library is designed to be lightweight, and have minimal memory usage.
Based on:
It is designed to read an write Excel compatible spreadsheets in (Office 2007+) XLSX format:
- supports PHP 8+
- takes UTF-8 encoded input
- multiple worksheets
- supports currency/date/numeric cell formatting, simple and array formulas
- supports basic cell styling
- supports writing huge 100K+ row spreadsheets
Documentation:
- http://www.ecma-international.org/publications/standards/Ecma-376.htm
- http://officeopenxml.com/SSstyles.php
Usage
Installing
Use Composer:
Reading
Open an Excel file:
Get a list of the sheets:
Get the data from a sheet:
Writing
Simple example:
Simple/Advanced Cell Formats:
Simple cell formats map to more advanced cell formats
simple formats | format code |
---|---|
string | @ |
integer | 0 |
date | YYYY-MM-DD |
datetime | YYYY-MM-DD HH:MM:SS |
time | HH:MM:SS |
price | #,##0.00 |
dollar | [$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00 |
euro | #,##0.00 [$€-407];[RED]-#,##0.00 [$€-407] |
Basic cell styles have been available since version 0.30
style | allowed values |
---|---|
font | Arial, Times New Roman, Courier New, Comic Sans MS |
font-size | 8,9,10,11,12 ... |
font-style | bold, italic, underline, strikethrough or multiple ie: 'bold,italic' |
border | left, right, top, bottom, or multiple ie: 'top,left' |
border-style | thin, medium, thick, dashDot, dashDotDot, dashed, dotted, double, hair, mediumDashDot, mediumDashDotDot, mediumDashed, slantDashDot |
border-color | #RRGGBB, ie: #ff99cc or #f9c |
color | #RRGGBB, ie: #ff99cc or #f9c |
fill | #RRGGBB, ie: #eeffee or #efe |
halign | general, left, right, justify, center |
valign | bottom, center, distributed |
textRotation | 0-360 |
All versions of excelerate with dependencies
PHP Build Version
Package Version
Requires
php Version
^8.0
ext-zip Version *
ext-simplexml Version *
ext-zip Version *
ext-simplexml Version *
The package bcostea/excelerate contains the following files
Loading the files please wait ....