29 个 PHP 的 Excel 处置类-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

29 个 PHP 的 Excel 处置类

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 pm 12:11 PM

excelfilesimportnbsp

29 个 PHP 的 Excel 处理类

下面的 PHP Excel 处理类中，包含 Excel 读写、导入导出等相关的类，列表如下：

　PHP Excel Reader classes

　　1. Read Excel Spreadsheets using COM

　　Umesh Rai (India)

　　2. Read Excel Binary .XLS Files in Pure PHP

　　Ruslan V. Uss (Russian Federation)

　　3. Read Excel Spreadsheets using ODBC

　　khalil Majdalawi (Jordan)

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

　　Andrew Aculana (Phillippines)

　　5. Read Simple Excel XML files (.XLSX)

　　Sergey Shuchkin (Russian Federation)

　　6. Read Excel generated CSV files

　　Ben Vautier (Australia)

　　PHP Excel Writer classes

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

　　Sergey Sergeevich (Russian Federation)

　　8. Generate Excel files using templates

　　Skrol29 (France)

　　9. Write Excel XML (.XLSX) files

　　Harish Chauhan (India)

　　10. Write Excel-compatible CSV files in pure PHP

　　H. Poort (The Nederlands)

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

　　Xavier Noguer (Chile)

　PHP Excel Import classes

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

　　Gianluca Zanferrari (Italy)

　　13. Import data from MySQL to Excel

　　Harish Chauhan (India)

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

　　dzaiacuck (Brazil)

　　15. Import data from MySQL to Excel HTML

　　raju mazumder (Bangladesh)

　　16. Import data from MySQL to Excel Sheets and Charts

　　Rafael de Pablo (Spain)

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

　　Erh-Wen, Kuo (United States)

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

　　Gianluca Zanferrari (Italy)

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

　　enri_pin (Greece)

　PHP Excel Export classes

　　20. Export data from Excel to JSON format

　　Karl Holz (Canada)

　PHP Excel Reader and Writer classes

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

　　Craig Smith (New Zealand)

　　22. Manipulate Excel spreadsheet files in XML format

　　Herry Ramli (Indonesia)

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

　　Ilya Eliseev (Russian Federation)

　　24. Manipulate Excel spreadsheet files using COM objects

　　Alain Samoun

　Special PHP Excel Classes

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

　　Ignatius Teo (Australia)

　　26. Excel MROUND function

　　Steve Winnington (United Kingdom)

　　27. Excel Financial Functions

　　Enrique Garcia M. (Colombia)

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

　　Giampaolo Losito (Italy)

　　29. Retrieve Application Internationalization Texts from Excel files

　　Johan Barbier (France)

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

PHP Performance Tuning for High Traffic WebsitesMay 14, 2025 am 12:13 AM

ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

Dependency Injection in PHP: Code Examples for BeginnersMay 14, 2025 am 12:08 AM

You should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.

PHP Performance: is it possible to optimize the application?May 14, 2025 am 12:04 AM

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

PHP Performance Optimization: The Ultimate GuideMay 14, 2025 am 12:02 AM

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

See all articles