Table of Contents
30 个 PHP 的 Excel 处理类,phpexcel
 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 处理类,phpexcel

30 个 PHP 的 Excel 处理类,phpexcel

Jun 13, 2016 am 08:59 AM
phpexcel

30 个 PHP 的 Excel 处理类,phpexcel

下面的 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)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks 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 development: Use PHPExcel to process Excel files PHP development: Use PHPExcel to process Excel files Jun 15, 2023 pm 03:45 PM

With the advent of the digital age, data has become the most important part of our daily lives and work, and Excel files have become one of the important tools for data processing. I believe that many PHP developers will often encounter the use of Excel files for data processing and operations at work. This article will introduce you to the methods and precautions for using the PHPExcel library to process Excel files. What is PHPExcel? PHPExcel is a PHP class

Complete Guide: How to process Excel files using php extension PHPExcel Complete Guide: How to process Excel files using php extension PHPExcel Jul 28, 2023 pm 10:01 PM

Complete Guide: How to Process Excel Files Using PHP Extension PHPExcel Introduction: Excel files are often used as a common format for data storage and exchange when processing large amounts of data and statistical analysis. Using the PHP extension PHPExcel, we can easily read, write and modify Excel files to effectively process Excel data. This article will introduce how to use the PHP extension PHPExcel to process Excel files and provide code examples. 1. Install PHPExc

How to use phpexcel to convert Excel files to CSV files and open them How to use phpexcel to convert Excel files to CSV files and open them Mar 27, 2023 pm 04:16 PM

​PHPEXCEL is an excellent PHP class library for reading and writing Excel files. It provides a very sufficient API that allows us to use PHP to read and write Excel files. Sometimes, we need to convert Excel files into CSV files for use on some occasions. So, this article mainly describes how to use the PHPEXCEL class library to convert Excel files into CSV files and open them.

How to use PHPExcel to process Excel files? How to use PHPExcel to process Excel files? Jun 01, 2023 pm 02:01 PM

PHPExcel is an open source PHP library for processing Microsoft Excel (.xls and .xlsx) files. It can read, write and operate Excel files, and provides a wealth of functions and methods. Using the PHPExcel library in PHP projects, you can quickly and easily process Excel files and implement functions such as data import, export and data processing. This article will introduce how to use PHPExcel to process Excel files. 1. To install PHPExcel, use

PHP development tips: How to use PHPExcel and PHPExcel_IOFactory to operate MySQL database PHP development tips: How to use PHPExcel and PHPExcel_IOFactory to operate MySQL database Jul 02, 2023 pm 02:28 PM

PHP development tips: How to use PHPExcel and PHPExcel_IOFactory to operate MySQL database Overview: In web development, processing Excel files is a common and important task. PHPExcel is a powerful and easy-to-use PHP library that can help us read and write Excel files. This article will introduce how to use PHPExcel and PHPExcel_IOFactory libraries to operate MySQL database. step 1

Create Excel files using PHP and PHPExcel Create Excel files using PHP and PHPExcel May 11, 2023 am 08:40 AM

In today's era of rapid information transfer, data processing and storage have become increasingly important. The use of Excel tables is the first choice for many people because Excel tables can integrate various data and can be easily analyzed and processed. In order to complete the creation of Excel tables more efficiently, we can use two powerful tools, PHP and PHPExcel. In this article, we will introduce how to create Excel files using PHP and PHPExcel. 1. Install PHPExcel first

PHP development skills: How to use PHPExcel to operate MySQL database PHP development skills: How to use PHPExcel to operate MySQL database Jul 02, 2023 pm 12:21 PM

PHP development skills: How to use PHPExcel to operate MySQL database. With the booming development of the Internet, a large amount of data is stored in the database, and operations such as import, export, and processing are required. In PHP development, PHPExcel is a powerful library that can simplify the interaction with Excel files and realize the import and export of data. This article will introduce how to use PHPExcel to operate the MySQL database and implement data import and export functions. Installation and configuration of PHPExcel

Why phpexcel has become the focus of PHP developers Why phpexcel has become the focus of PHP developers Mar 27, 2023 pm 06:15 PM

PHPExcel is an open source PHP library for processing Microsoft Excel files. It can read, create, modify and save Excel files. It is a powerful and highly customizable tool that can be used to handle tasks such as data analysis, report generation, data import and export, etc. In this article, we will introduce why PHPExcel has become the focus of PHP developers.

See all articles