29个PHP 的Excel处理类库,方便处理Excel

PHP

PHP Excel Reader classes

1. Read Excel Spreadsheets using COM

网址:http://www.phpclasses.org/package/1808-PHP-Read-data-from-Excel-files-using-COM-objects.html

2. Read Excel Binary .XLS Files in Pure PHP

网址:http://www.phpclasses.org/package/6235-PHP-Parse-and-access-binary-Excel-files-in-pure-PHP.html#information

3. Read Excel Spreadsheets using ODBC

网址:http://www.phpclasses.org/package/3797-PHP-Access-Excel-spreadsheets-as-databases-using-ODBC.html

4. Read Excel Worksheets in XML format (.XLSX)

网址:http://www.phpclasses.org/package/3187-PHP-Read-and-write-data-to-Excel-XML-worksheets.html

5. Read Simple Excel XML files (.XLSX)

网址:http://www.phpclasses.org/package/6279-PHP-Parse-and-retrieve-data-from-Excel-XLS-files.html

6. Read Excel generated CSV files

网址:http://www.phpclasses.org/package/2672-PHP-Retrieve-data-from-CSV-files-Ms-Excel-too-.html

PHP Excel Writer classes

7. Write Excel Binary file (.XLS) from Array data

网址:http://www.phpclasses.org/package/6857-PHP-Generate-Excel-2003-spreadsheet-from-array-of-data.html

8. Generate Excel files using templates

网址:http://www.phpclasses.org/package/3159-PHP-Generate-Excel-spreadsheets-using-template-plug-in.html

9. Write Excel XML (.XLSX) files

网址:http://www.phpclasses.org/package/2037-PHP-Generate-spreadsheet-files-Excel-xls-XML-format.html

10. Write Excel-compatible CSV files in pure PHP

网址:http://www.phpclasses.org/package/4267-PHP-Generate-CSV-files-in-pure-PHP.html

11. Write Excel binary files (.XLS) based on Perl ExcelWriter

网址:http://www.phpclasses.org/package/767-PHP-Classes-for-generating-Excel-files.html

PHP Excel Import classes

12. Import Excel cells pasted as CSV in a form input

网址:http://www.phpclasses.org/package/7879-PHP-Convert-a-pasted-Excel-document-to-the-CSV-format.html

13. Import data from MySQL to Excel

网址:http://www.phpclasses.org/package/2038-PHP-Export-data-from-a-MySQL-database-to-Excel-files.html

14. Import MySQL database table records into binary Excel file (.XLS)

网址:http://www.phpclasses.org/package/1590-PHP-Export-database-table-records-in-Excel-XLS-format.html

15. Import data from MySQL to Excel HTML

网址:http://www.phpclasses.org/package/4424-PHP-Generate-HTML-tables-from-MySQL-query-results.html

16. Import data from MySQL to Excel Sheets and Charts

网址:http://www.phpclasses.org/package/2063-PHP-Output-Excel-sheets-and-charts-from-data-in-MySQL.html

17. Import data from MySQL and serve Excel file for download

网址:http://www.phpclasses.org/package/644-PHP-Easy-way-to-stream-Mysql-sql-content-to-Excel-.html

18. Import MySQL table columns into Excel XML file (.XLSX)

网址:http://www.phpclasses.org/package/8019-PHP-Export-MySQL-table-records-to-Excel-XML-format.html

19. Import MySQL, PostgreSQL, SQLite and SQL Server database tables into Excel files

网址:http://www.phpclasses.org/package/8530-PHP-Show-edit-and-export-database-table-records.html

PHP Excel Export classes

20. Export data from Excel to JSON format

网址:http://www.phpclasses.org/package/7965-PHP-Convert-data-from-Excel-spreadsheet-to-JSON-format.html

21. Read and write Excel binary (.XLS) or XML (.XLS) or CVS files

网址:http://www.phpclasses.org/package/8169-PHP-Import-and-export-Excel-files-to-XLS-XLSX-and-CSV.html

22. Manipulate Excel spreadsheet files in XML format

网址:http://www.phpclasses.org/package/4722-PHP-Manipulate-Excel-spreadsheet-files-in-XML-format.html

23. Modify Excel spreadsheet files in XML format (.XLSX)

网址:http://www.phpclasses.org/package/8573-PHP-Read-and-write-Excel-spreadsheets-in-XLSX-format.html

24. Manipulate Excel spreadsheet files using COM objects

网址:http://www.phpclasses.org/package/86-PHP-Manipulate-Excel-files-using-the-COM-interface.html

Special PHP Excel Classes

25. Reading and writing Excel files as if they were files using a stream handler

网址:http://www.phpclasses.org/package/1919-PHP-Stream-wrapper-to-read-and-write-MS-Excel-files.html

26. Excel MROUND function

网址:http://www.phpclasses.org/package/8378-PHP-Round-numbers-to-nearest-multiple-as-Excel-MROUND.html

27. Excel Financial Functions

网址:http://www.phpclasses.org/package/892-PHP-Financial-functions-with-the-Excel-function-names-.html

28. Indexing Excel and other file types for searching with Lucene

网址:http://www.phpclasses.org/package/8330-PHP-Index-and-search-documents-using-Lucene-or-MySQL.html

29. Retrieve Application Internationalization Texts from Excel files

网址:http://www.phpclasses.org/package/4214-PHP-Retrieve-and-edit-internationalized-texts.html

  • 发表于:
  • 原文链接:https://kuaibao.qq.com/s/20180909A1IGRL00?refer=cp_1026
  • 腾讯「云+社区」是腾讯内容开放平台帐号(企鹅号)传播渠道之一,根据《腾讯内容开放平台服务协议》转载发布内容。

扫码关注云+社区

领取腾讯云代金券