PHPExcel developer documentation [Chinese version]

: This article mainly introduces the PHPExcel developer documentation [Chinese version]. For more information about PHP tutorials, see. 1. Preface

First of all, I hope you can give some comments and guidance when translating this document for the first time.

PhpExcel official website pointed out: PHPExcel is based on OPENXML standards, using PHP to read and write and create Excel file workbooks engine.

Excel 2007 (Office OpenXML).xlsx, CSV, Libre/OpenOffice Cacl. ods, Gnumeric, PDF, HTML, etc. This project is built around Microsoft's OpenXML standard and PHP.

This project provides a series of new features, such as setting workbook metadata (author, title, description ,......) , Multiple worksheets, different fonts and font styles, cell borders, fill, gradient, add images to workbooks, computation formulas, convert to multiple file types!

2. prerequisites

2.1. Software Requirements

2.2. Installation Instructions

2.3. start

2.4. Useful links and tools

2.4.1. OpenXML/spreadsheez

2.4.2. FAQs

2.4.3. tutorial

3. Structure

3.1. Principles

3.2. inert loading

3.3. workbook loading memory

3.4. read/write handle

3.5. smooth interface

4. create a workbook

4.1. php Excel class

4.1.1. load a workbook from a file

4.1.2. create a new Workbook

4.2. configuration settings

4.2.1. cell cache

4.2.2. language/Localization

4.3. clear workbooks from memory

4.4. worksheet

4.4.1. add a worksheet

4.4.2. copy a worksheet

4.4.3. delete a worksheet

4.5. access (access) unit

4.5.1. set the cell value through coordinates

4.5.2. retrieve cells by coordinate

4.5.3. set cell values through columns and rows

4.5.4. retrieve cell values through columns and rows

4.5.5. cyclic cells

4.5.6. Using value binders to facilitate data entry

4.6. PHPExcel recipes

4.6.1. Setting a spreadsheet's metadata

4.6.2. Setting a spreadsheet's active sheet

4.6.3. Write a date or time into a cell

4.6.4. Write a formula into a cell

4.6.5. Locale Settings for Formulae

4.6.6. Write a newline character "\ n" in a cell (ALT + "Enter ")

4.6.7. Explicitly set a cell's datatype

4.6.8. Change a cell into a clickable URL

4.6.9. Setting a worksheet's page orientation and size

4.6.10. Page Setup: Scaling options

4.6.11. Page margins

4.6.12. Center a page horizontally/vertically

4.6.13. Setting the print header and footer of a worksheet

4.6.14. Setting printing breaks on a row or column

4.6.15. Show/hide gridlines when printing

4.6.16. Setting rows/columns to repeat at top/left

4.6.17. Specify printing area

4.6.18. Formatting cells

4.6.19. Number formats

4.6.20. Alignment and wrap text

4.6.21. Setting the default style of a workbook

4.6.22. Styling cell borders

4.6.23. Conditional formatting a cell

4.6.24. Add a comment to a cell

4.6.25. Apply autofilter to a range of cells

4.6.26. Setting security on a spreadsheet

4.6.27. Setting data validation on a cell

4.6.28. Setting a column's width

4.6.29. Show/hide a column

4.6.30. Group/outline a column

4.6.31. Setting a row's height

4.6.32. Show/hide a row

4.6.33. Group/outline a row

4.6.34. Merge/unmerge cells

4.6.35. Inserting rows/columns

4.6.36. Add a drawing to a worksheet

4.6.37. Reading Images from a worksheet

4.6.38. Add rich text to a cell

4.6.39. Define a named range

4.6.40. Redirect output to a client's web browser

4.6.41. Setting the default column width

4.6.42. Setting the default row height

4.6.43. Add a GD drawing to a worksheet

4.6.44. Setting worksheet zoom level

4.6.45. Sheet tab color

4.6.46. Creating worksheets in a workbook

4.6.47. Hidden worksheets (Sheet states)

4.6.48. Right-to-left worksheet

5. grouping Ming formula calculations

5.1. Using the PHPExcel calculation engine

5.2. Known limitations

5.2.1. Operator precedence

5.2.2. Formulas involving numbers and text

6. Reading and writing to file

6.1. PHPExcel_IOFactory

6.1.1. Creating PHPExcel_Reader_IReader using PHPExcel_IOFactory

6.1.2. Creating PHPExcel_Writer_IWriter using PHPExcel_IOFactory

6.2. Excel 2007 (SpreadsheetML) file format

6.2.1. PHPExcel_Reader_Excel2007

6.2.2. PHPExcel_Writer_Excel2007

6.3. Excel 5 (BIFF) file format

6.3.1. PHPExcel_Reader_Excel5

6.3.2. PHPExcel_Writer_Excel5

6.4. Excel 2003 XML file format

6.4.1. PHPExcel_Reader_Excel2003XML

6.5. Symbolic LinK (SYLK)

6.5.1. PHPExcel_Reader_SYLK

6.6. Open/Libre Office (. ods)

6.6.1. PHPExcel_Reader_OOCalc

6.7. CSV (Comma Separated Values)

6.7.1. PHPExcel_Reader_CSV

6.7.2. PHPExcel_Writer_CSV

6.8. HTML

6.8.1. PHPExcel_Reader_HTML

6.8.2. PHPExcel_Writer_HTML

6.9. PDF

6.9.1. PHPExcel_Writer_PDF

6.10. Generating Excel files from templates (read, modify, write)

7. Credits 50

Appendix A: Valid array keys for style applyFromArray ()

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.

The above section introduces the PHPExcel developer documentation [Chinese version], including some content. I hope my friends who are interested in PHP tutorials can help me.