| 1441 |
ariadna |
1 |
# PhpSpreadsheet
|
|
|
2 |
|
|
|
3 |
[](https://github.com/PHPOffice/PhpSpreadsheet/actions)
|
|
|
4 |
[](https://scrutinizer-ci.com/g/PHPOffice/PhpSpreadsheet/?branch=master)
|
|
|
5 |
[](https://scrutinizer-ci.com/g/PHPOffice/PhpSpreadsheet/?branch=master)
|
|
|
6 |
[](https://packagist.org/packages/phpoffice/phpspreadsheet)
|
|
|
7 |
[](https://packagist.org/packages/phpoffice/phpspreadsheet)
|
|
|
8 |
[](https://packagist.org/packages/phpoffice/phpspreadsheet)
|
|
|
9 |
[](https://gitter.im/PHPOffice/PhpSpreadsheet)
|
|
|
10 |
|
|
|
11 |
PhpSpreadsheet is a library written in pure PHP and offers a set of classes that
|
|
|
12 |
allow you to read and write various spreadsheet file formats such as Excel and LibreOffice Calc.
|
|
|
13 |
|
|
|
14 |
## Installation
|
|
|
15 |
|
|
|
16 |
See the [install instructions](https://phpspreadsheet.readthedocs.io/en/latest/#installation).
|
|
|
17 |
|
|
|
18 |
## Documentation
|
|
|
19 |
|
|
|
20 |
Read more about it, including install instructions, in the [official documentation](https://phpspreadsheet.readthedocs.io). Or check out the [API documentation](https://phpoffice.github.io/PhpSpreadsheet).
|
|
|
21 |
|
|
|
22 |
Please ask your support questions on [StackOverflow](https://stackoverflow.com/questions/tagged/phpspreadsheet), or have a quick chat on [Gitter](https://gitter.im/PHPOffice/PhpSpreadsheet).
|
|
|
23 |
|
|
|
24 |
## Patreon
|
|
|
25 |
|
|
|
26 |
I am now running a [Patreon](https://www.patreon.com/MarkBaker) to support the work that I do on PhpSpreadsheet.
|
|
|
27 |
|
|
|
28 |
Supporters will receive access to articles about working with PhpSpreadsheet, and how to use some of its more advanced features.
|
|
|
29 |
|
|
|
30 |
Posts already available to Patreon supporters:
|
|
|
31 |
- The Dating Game
|
|
|
32 |
- A look at how MS Excel (and PhpSpreadsheet) handle date and time values.
|
|
|
33 |
- Looping the Loop
|
|
|
34 |
- Advice on Iterating through the rows and cells in a worksheet.
|
|
|
35 |
|
|
|
36 |
And for Patrons at levels actively using PhpSpreadsheet:
|
|
|
37 |
- Behind the Mask
|
|
|
38 |
- A look at Number Format Masks.
|
|
|
39 |
|
|
|
40 |
The Next Article (currently Work in Progress):
|
|
|
41 |
- Formula for Success
|
|
|
42 |
- How to debug formulae that don't produce the expected result.
|
|
|
43 |
|
|
|
44 |
|
|
|
45 |
My aim is to post at least one article each month, taking a detailed look at some feature of MS Excel and how to use that feature in PhpSpreadsheet, or on how to perform different activities in PhpSpreadsheet.
|
|
|
46 |
|
|
|
47 |
Planned posts for the future include topics like:
|
|
|
48 |
- Tables
|
|
|
49 |
- Structured References
|
|
|
50 |
- AutoFiltering
|
|
|
51 |
- Array Formulae
|
|
|
52 |
- Conditional Formatting
|
|
|
53 |
- Data Validation
|
|
|
54 |
- Value Binders
|
|
|
55 |
- Images
|
|
|
56 |
- Charts
|
|
|
57 |
|
|
|
58 |
After a period of six months exclusive to Patreon supporters, articles will be incorporated into the public documentation for the library.
|
|
|
59 |
|
|
|
60 |
## PHPExcel vs PhpSpreadsheet ?
|
|
|
61 |
|
|
|
62 |
PhpSpreadsheet is the next version of PHPExcel. It breaks compatibility to dramatically improve the code base quality (namespaces, PSR compliance, use of latest PHP language features, etc.).
|
|
|
63 |
|
|
|
64 |
Because all efforts have shifted to PhpSpreadsheet, PHPExcel will no longer be maintained. All contributions for PHPExcel, patches and new features, should target PhpSpreadsheet `master` branch.
|
|
|
65 |
|
|
|
66 |
Do you need to migrate? There is [an automated tool](/docs/topics/migration-from-PHPExcel.md) for that.
|
|
|
67 |
|
|
|
68 |
## License
|
|
|
69 |
|
|
|
70 |
PhpSpreadsheet is licensed under [MIT](https://github.com/PHPOffice/PhpSpreadsheet/blob/master/LICENSE).
|