30 个 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)

文章转载自 开源中国社区 [http://www.oschina.net]

时间: 2024-09-15 05:52:29

30 个 PHP 的 Excel 处理类的相关文章

EpPlus读取生成Excel帮助类+读取csv帮助类+Aspose.Cells生成Excel帮助类

大部分功能逻辑都在,少量自定义异常类和扩展方法 ,可用类似代码自己替换 //EpPlus读取生成Excel帮助类+读取csv帮助类,epplus只支持开放的Excel文件格式:xlsx,不支持 xls格式 /* ============================================================================== * 功能描述:EppHelper * 创 建 者:蒲奎民 * 创建日期:2016-07-21 14:30:35 * CLR Ver

php导出中文内容excel文件类实例_php技巧

本文实例讲述了php导出中文内容excel文件类.分享给大家供大家参考.具体如下: <?php class toExcel{ public $link = null; function __construct(){ } /*************************************************************************** * $mapping:数组格式头信息$map=array('No','Name','Email','Age'); * $dat

java常用工具类之Excel操作类及依赖包下载_java

依赖包下载:http://xiazai.jb51.net/201407/tools/java-excel-dependency(jb51.net).rar Excel工具类ExcelUtil.java源码: package com.itjh.javaUtil; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStr

C#常用工具类——Excel操作类

/// 常用工具类--Excel操作类 /// <para> ------------------------------------------------</para> /// <para> CreateConnection:根据Excel文件路径和EXCEL驱动版本生成OleConnection对象实例</para> /// <para> ExecuteDataSet:执行一条SQL语句,返回一个DataSet对象</para>

php excel操作类phpExcel用法介绍

下面是总结的几个使用方法 include 'PHPExcel.php'; include 'PHPExcel/Writer/Excel2007.php'; //或者include 'PHPExcel/Writer/Excel5.php'; 用于输出.xls的 创建一个excel $objPHPExcel = new PHPExcel(); 保存excel-2007格式 $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); //或者$o

我写的一个将数据库数据导出到EXCEL的类(ASP)

excel|数据|数据库 clsExport2Excel.asp<%'类开始Class clsExport2Excel '声明常量.变量Private strFilePath,strTitle,strSql,strField,strRows,strColsPrivate strCn,strHtml,strPathPrivate objDbCn,objRsPrivate objXlsApp,objXlsWorkBook,objXlsWorkSheetPrivate arrField '初始化类Pr

数据库备份转换为Excel文件类

注意:此版本的类暂时只支持一次转换一个数据表,即一个数据表只能对应一个Excel文件.如果转换一个数据表后不更换TargetFile参数,则将覆盖以前的表数据!!!! 使用方法请仔细阅读下面的注解说明!! <% Class DataBaseToExcel ''/*************************************************************************** ''/* 转移数据到Excel文件(备份数据库类 Excel篇) V1.0 ''/*作

自己封装的poi操作Excel工具类

       在上一篇文章<使用poi读写Excel>中分享了一下poi操作Excel的简单示例,这次要分享一下我封装的一个Excel操作的工具类.        该工具类主要完成的功能是:读取Excel.汇总Excel的功能.在读取时,可以设定开始和结束读取的位置.设定是否读取多个sheet.设定读取那个或者那些sheet等.在汇总时,如设定是否覆盖目标文件.设定是否比较检查重复内容.设定检查重复的列索引等功能.具体来演示一下吧:        工具类源码: package com.tgb.

php中pdf word excel操作类分享

1,php excelreader操作excel的php类,生成,读取excel等.功能很强大. 下载地址:http://sourceforge.net/projects/phpexcelreader/ 解压后,里面有很多例子,调用方法简单. 例1  代码如下 复制代码 <?php /**  *  * @copyright 2007-2012 Xiaoqiang.  * @author Xiaoqiang.Wu <jamblues@gmail.com>  * @version 1.01