Phpexcel Developer documentation [Chinese version]

1. Write in the previous words

First of all, the first translation of the document, flawed, I hope you give some advice and guidance.

Phpexcel said: Phpexcel is based on the OPENXML standard, using PHP to read and write and create Excel file spreadsheet engine.

The project provides a series of classes for the PHP programming language that allow you to read and write spreadsheets in different file formats, such as Excel (BIFF). xls, Excel (Office OpenXML). xlsx, CSV, Libre/openoffice Cacl. ODS, Gnumeric, PDF, HTML, and more. The project is built around Microsoft's OPENXML Standard and PHP.

The project provides a series of new features, such as setting up spreadsheet metadata (author, title, Description, ...). ), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, add pictures to spreadsheets, calculate formulas, convert to multiple file types!

2. Pre-conditions

2.1. Software Requirements

2.2. Installation Instructions

2.3. Start

2.4. Useful links and tools

2.4.1. Openxml/spreadsheetm

2.4.2. Frequently Asked Questions

2.4.3. Tutorials

3. Structure

3.1. Principle

3.2. Lazy Loading

3.3. Loading the spreadsheet into memory

3.4. Read and write handles

3.5. Smooth interface

4. Create a spreadsheet

4.1. Phpexcel Class

4.1.1. Loading workbooks from a file

4.1.2. Creating a new workbook

4.2. Configuration settings

4.2.1. Unit Cache

4.2.2. Language/Localization

4.3. Clear the workbook from memory

4.4. Worksheets

4.4.1. Adding worksheets

4.4.2. Copying worksheets

4.4.3. Deleting worksheets

4.5. Access (access) unit

4.5.1. Setting the value of a cell by coordinates

4.5.2. Retrieving cells by coordinates

4.5.3. Setting values for cells by columns and rows

4.5.4. Retrieving cell values from 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 to 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. 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. Excel (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 NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

The above describes the Phpexcel developer documentation [Chinese version], including aspects of the content, I hope that the PHP tutorial interested in a friend helpful.

