Table of Contents
PHP Excel Reader classes
1.?Read Excel Spreadsheets using COM
2.?Read Excel Binary .XLS Files in Pure PHP
3.?Read Excel Spreadsheets using ODBC
4.?Read Excel Worksheets in XML format (.XLSX)
5.?Read Simple Excel XML files (.XLSX)
6.?Read Excel generated CSV files
PHP Excel Writer classes
7.?Write Excel Binary file (.XLS) from Array data
8.?Generate Excel files using templates
9.?Write Excel XML (.XLSX) files
10.?Write Excel-compatible CSV files in pure PHP
11.?Write Excel binary files (.XLS) based on Perl ExcelWriter
PHP Excel Import classes
12.?Import Excel cells pasted as CSV in a form input
13.?Import data from MySQL to Excel
14.?Import MySQL database table records into binary Excel file (.XLS)
15.?Import data from MySQL to Excel HTML
16.?Import data from MySQL to Excel Sheets and Charts
17.?Import data from MySQL and serve Excel file for download
18.?Import MySQL table columns into Excel XML file (.XLSX)
19.?Import MySQL, PostgreSQL, SQLite and SQL Server database tables into Excel files
PHP Excel Export classes
20.?Export data from Excel to JSON format
PHP Excel Reader and Writer classes
21.?Read and write Excel binary (.XLS) or XML (.XLS) or CVS files
22.?Manipulate Excel spreadsheet files in XML format
23.?Modify Excel spreadsheet files in XML format (.XLSX)
24.?Manipulate Excel spreadsheet files using COM objects
Special PHP Excel Classes
25.?Reading and writing Excel files as if they were files using a stream handler
26.?Excel MROUND function
27.?Excel Financial Functions
28.?Indexing Excel and other file types for searching with Lucene
29.?Retrieve Application Internationalization Texts from Excel files
Home php教程 php手册 30 个 PHP 的 Excel 工具类

30 个 PHP 的 Excel 工具类

Jun 06, 2016 pm 08:14 PM
excel php deal with tool kind

下面的 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.?Re

下面的 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 of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP and Python: Comparing Two Popular Programming Languages PHP and Python: Comparing Two Popular Programming Languages Apr 14, 2025 am 12:13 AM

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

How to optimize the performance of debian readdir How to optimize the performance of debian readdir Apr 13, 2025 am 08:48 AM

In Debian systems, readdir system calls are used to read directory contents. If its performance is not good, try the following optimization strategy: Simplify the number of directory files: Split large directories into multiple small directories as much as possible, reducing the number of items processed per readdir call. Enable directory content caching: build a cache mechanism, update the cache regularly or when directory content changes, and reduce frequent calls to readdir. Memory caches (such as Memcached or Redis) or local caches (such as files or databases) can be considered. Adopt efficient data structure: If you implement directory traversal by yourself, select more efficient data structures (such as hash tables instead of linear search) to store and access directory information

How to recycle packages that are no longer used How to recycle packages that are no longer used Apr 13, 2025 am 08:51 AM

This article describes how to clean useless software packages and free up disk space in the Debian system. Step 1: Update the package list Make sure your package list is up to date: sudoaptupdate Step 2: View installed packages Use the following command to view all installed packages: dpkg--get-selections|grep-vdeinstall Step 3: Identify redundant packages Use the aptitude tool to find packages that are no longer needed. aptitude will provide suggestions to help you safely delete packages: sudoaptitudesearch '~pimportant' This command lists the tags

How to use Nginx logs to improve website speed How to use Nginx logs to improve website speed Apr 13, 2025 am 09:09 AM

Website performance optimization is inseparable from in-depth analysis of access logs. Nginx log records the detailed information of users visiting the website. Cleverly using this data can effectively improve the speed of the website. This article will introduce several website performance optimization methods based on Nginx logs. 1. User behavior analysis and optimization. By analyzing the Nginx log, we can gain a deep understanding of user behavior and make targeted optimization based on this: High-frequency access IP identification: Find the IP address with the highest access frequency, and optimize the server resource configuration for these IP addresses, such as increasing bandwidth or improving the response speed of specific content. Status code analysis: analyze the frequency of different HTTP status codes (such as 404 errors), find out problems in website navigation or content management, and proceed

How debian readdir integrates with other tools How debian readdir integrates with other tools Apr 13, 2025 am 09:42 AM

The readdir function in the Debian system is a system call used to read directory contents and is often used in C programming. This article will explain how to integrate readdir with other tools to enhance its functionality. Method 1: Combining C language program and pipeline First, write a C program to call the readdir function and output the result: #include#include#include#includeintmain(intargc,char*argv[]){DIR*dir;structdirent*entry;if(argc!=2){

How Debian improves Hadoop data processing speed How Debian improves Hadoop data processing speed Apr 13, 2025 am 11:54 AM

This article discusses how to improve Hadoop data processing efficiency on Debian systems. Optimization strategies cover hardware upgrades, operating system parameter adjustments, Hadoop configuration modifications, and the use of efficient algorithms and tools. 1. Hardware resource strengthening ensures that all nodes have consistent hardware configurations, especially paying attention to CPU, memory and network equipment performance. Choosing high-performance hardware components is essential to improve overall processing speed. 2. Operating system tunes file descriptors and network connections: Modify the /etc/security/limits.conf file to increase the upper limit of file descriptors and network connections allowed to be opened at the same time by the system. JVM parameter adjustment: Adjust in hadoop-env.sh file

The Enduring Relevance of PHP: Is It Still Alive? The Enduring Relevance of PHP: Is It Still Alive? Apr 14, 2025 am 12:12 AM

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

How Debian OpenSSL prevents man-in-the-middle attacks How Debian OpenSSL prevents man-in-the-middle attacks Apr 13, 2025 am 10:30 AM

In Debian systems, OpenSSL is an important library for encryption, decryption and certificate management. To prevent a man-in-the-middle attack (MITM), the following measures can be taken: Use HTTPS: Ensure that all network requests use the HTTPS protocol instead of HTTP. HTTPS uses TLS (Transport Layer Security Protocol) to encrypt communication data to ensure that the data is not stolen or tampered during transmission. Verify server certificate: Manually verify the server certificate on the client to ensure it is trustworthy. The server can be manually verified through the delegate method of URLSession

See all articles