PHPExcel Developer Documentation [Chinese Version]

1. What I wrote before

First of all, this is the first time I have translated this document and it is full of loopholes. I hope you can give me some advice and guidance.

phpExcel official website points out: PHPExcel is an engine based on the OPENXML standard that uses PHP to read, write and create Excel file spreadsheets.

This project provides a series of classes for the PHP programming language that allow you to read and write spreadsheets in different file formats, like Excel (BIFF).xls, Excel 2007 (Office OpenXML).xlsx, CSV, Libre/OpenOffice Cacl .ods , Gnumeric, PDF, HTML, etc. The project is built around Microsoft's OpenXML standard and PHP.

This project provides a series of new features, such as setting spreadsheet metadata (author, title, description,...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to spreadsheets Tables, calculation formulas, and conversion to multiple file types!

2. Prerequisites

2.1. Software requirements

2.2. Installation instructions

2.3. Getting started

2.4. Useful links and tools

2.4.1. OpenXML / SpreadsheetM

2.4.2. FAQ

2.4.3. Tutorial

3. Structure

3.1. Principle

3.2. Lazy loading

3.3. Load spreadsheet into memory

3.4. Read and write handle

3.5. Smooth interface

4. Create Spreadsheets

4.1. PHPExcel class

4.1.1. Load workbook from file

4.1.2. Create new workbook

4.2. Configuration settings

4.2.1. Cell cache

4.2.2 . Language/Localization

4.3. Clear workbook from memory

4.4. Worksheet

4.4.1. Add worksheet

4.4.2. Copy worksheet

4.4.3. Delete worksheet

4.5. Access (access) cells

4.5.1. Set the value of the cell by coordinates

4.5.2. Retrieve the cell by coordinates

4.5.3. Set the value of the cell by columns and rows

4.5 .4. Retrieving cell values ​​by columns and rows

4.5.5. Looping 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. 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. Performing 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.

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. )

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. Excel_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 Statement: This article is an original article by the blogger and may not be reproduced without the blogger's permission.

---

The above introduces the PHPExcel Developer Documentation [Chinese version], including relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.