PHPExcel developer documentation [Chinese version]

Source: Internet
Author: User
Tags php excel
: 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.