当前位置: 网学 > 编程文档 > PHP > 正文

php编程实现获取excel文档内容的代码实例

来源:Http://myeducs.cn 联系QQ:点击这里给我发消息 作者: 用户投稿 来源: 网络 发布时间: 13/06/22

define(''SPREADSHEET_EXCEL_READER_TYPE_MULBLANK'', 0xbe);
define(''SPREADSHEET_EXCEL_READER_TYPE_INDEX'', 0x20b);
define(''SPREADSHEET_EXCEL_READER_TYPE_SST'', 0xfc);
define(''SPREADSHEET_EXCEL_READER_TYPE_EXTSST'', 0xff);
define(''SPREADSHEET_EXCEL_READER_TYPE_CONTINUE'', 0x3c);
define(''SPREADSHEET_EXCEL_READER_TYPE_LABEL'', 0x204);
define(''SPREADSHEET_EXCEL_READER_TYPE_LABELSST'', 0xfd);
define(''SPREADSHEET_EXCEL_READER_TYPE_NUMBER'', 0x203);
define(''SPREADSHEET_EXCEL_READER_TYPE_NAME'', 0x18);
define(''SPREADSHEET_EXCEL_READER_TYPE_ARRAY'', 0x221);
define(''SPREADSHEET_EXCEL_READER_TYPE_STRING'', 0x207);
define(''SPREADSHEET_EXCEL_READER_TYPE_FORMULA'', 0x406);
define(''SPREADSHEET_EXCEL_READER_TYPE_FORMULA2'', 0x6);
define(''SPREADSHEET_EXCEL_READER_TYPE_FORMAT'', 0x41e);
define(''SPREADSHEET_EXCEL_READER_TYPE_XF'', 0xe0);
define(''SPREADSHEET_EXCEL_READER_TYPE_BOOLERR'', 0x205);
define(''SPREADSHEET_EXCEL_READER_TYPE_UNKNOWN'', 0xffff);
define(''SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR'', 0x22);
define(''SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS'', 0xE5);
define(''SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS'' , 25569);
define(''SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904'', 24107);
define(''SPREADSHEET_EXCEL_READER_MSINADAY'', 86400);
//define(''SPREADSHEET_EXCEL_READER_MSINADAY'', 24 * 60 * 60);
//define(''SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT'', "%.2f");
define(''SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT'', "%s");
/*
* Place includes, constant defines and php编程实现获取excel文档内容的代码实例_网学
浏览:
版权所有 QQ:3710167 邮箱:3710167@qq.com 网学网 [Myeducs.cn] 您电脑的分辨率是 像素
Copyright 2008-2015 myeducs.Cn www.myeducs.Cn All Rights Reserved
湘ICP备09003080号
GLOBAL settings here.
* Make sure they have appropriate docblocks to avoid phpDocumentor
* construing they are documented by the page-level docblock.
*/
/**
* A class for reading Microsoft Excel Spreadsheets.
*
* Originally developed by Vadim Tkachenko under the name PHPExcelReader.
* (http://sourceforge.net/projects/phpexcelreader)
* Based on the Java version by Andy Khan (http://www.3ppt.com). Now
* maintained by David Sanders. Reads only Biff 7 and Biff 8 formats.
*
* @category Spreadsheet
* @package Spreadsheet_Excel_Reader
* @author Vadim Tkachenko <vt@shoujidy.com>
* @copyright 2010-2011 The PHP Group
* @license http://www.php.net/license/3_0.txt PHP License 3.0
* @version Release: @package_version@
* @link http://pear.php.net/package/PackageName
* @see OLE, Spreadsheet_Excel_Writer
*/
class ReadexcelSystem{
/**
* Array of worksheets found
*
* @var array
* @access public
*/
var $boundsheets = array();
/**
* Array of format records found
*
* @var array
* @access public
*/
var $formatRecords = array();
/**
* todo
*
* @var array
* @access public
*/
var $sst = array();
/**
* Array of worksheets
*
* The data is stored in ''cells'' and the meta-data is stored in an array
* called ''cellsInfo''
*
* Example:
*
* $sheets --> ''cells'' --> row --> column --> Interpreted value
* --> ''cellsInfo'' --> row --> column --> ''type'' - Can be ''date'', ''number'', or ''unknown''
* --> ''raw'' - The raw data that Excel stores for that data cell
*
* @var array
* @acc
  • 上一篇资讯: PHP学习笔记之数组篇
  • 网学推荐

    免费论文

    原创论文

    浏览:
    设为首页 | 加入收藏 | 论文首页 | 论文专题 | 设计下载 | 网学软件 | 论文模板 | 论文资源 | 程序设计 | 关于网学 | 站内搜索 | 网学留言 | 友情链接 | 资料中心
    版权所有 QQ:3710167 邮箱:3710167@qq.com 网学网 [Myeducs.cn] 您电脑的分辨率是 像素
    Copyright 2008-2015 myeducs.Cn www.myeducs.Cn All Rights Reserved
    湘ICP备09003080号