Rumah > Artikel > pembangunan bahagian belakang > php读取execel内容_PHP教程

php读取execel内容_PHP教程

WBOYasal: 2016-07-20 11:05:42907semak imbas

define('ABC_CRITICAL', 0);
define('ABC_ERROR', 1);
define('ABC_ALERT', 2);
define('ABC_WARNING', 3);
define('ABC_NOTICE', 4);
define('ABC_INFO', 5);
define('ABC_DEBUG', 6);
define('ABC_TRACE', 7);
define('ABC_VAR_DUMP', 8);
define('ABC_NO_LOG', -1);
$php_version = split( ".", phpversion() );
if( $php_version[0] == 4 && $php_version[1] if( !function_exists('var_export') ) {
 function var_export( $exp, $ret ) {
ob_start();
var_dump( $exp );
$result = ob_get_contents();
ob_end_clean();
return $result;
}}}function print_bt()
{
print "n"; $cs = debug_backtrace(); for( $i = 1; $i { $item = $cs[ $i ]; for( $j = 0; $j if( is_string($item['args'][$j]) ) $item['args'][$j] = """ . $item['args'][$j] . """; $args = join(",", $item['args'] ); if( isset( $item['class'] ) ) $str = sprintf("%s(%d): %s%s%s(%s)", $item['file'], $item['line'], $item['class'], $item['type'], $item['function'], $args ); else $str = sprintf("%s(%d): %s(%s)", $item['file'], $item['line'], $item['function'], $args ); echo $str . " n"; }print "n";
}function _die( $str )
{
print "Script died with reason: $str
n";
print_bt();
exit();
}class DebugOut
{
var $priorities = array(ABC_CRITICAL => 'critical',
 ABC_ERROR => 'error',
 ABC_ALERT => 'alert',
 ABC_WARNING => 'warning',
 ABC_NOTICE => 'notice',
 ABC_INFO => 'info',
 ABC_DEBUG => 'debug',
 ABC_TRACE => 'trace',
 ABC_VAR_DUMP => 'dump'
 );
var $_ready = false;
var $_currentPriority = ABC_DEBUG;
var $_consumers = array();
var $_filename;
var $_fp;
var $_logger_name;
function DebugOut($name, $logger_name, $level ){
 $this->_filename = $name;
 $this->_currentPriority = $level;
 $this->_logger_name = $logger_name;
 if ($level > ABC_NO_LOG){
 $this->_openfile();
 }
 register_shutdown_function(array($this,"close"));
} function log($message, $priority = ABC_INFO) {
 if ($priority > $this->_currentPriority) {
 return false;
 }
 return $this->_writeLine($message, $priority, strftime('%b %d %H:%M:%S'));
} function dump($variable,$name) {
 $priority = ABC_VAR_DUMP;
 if ($priority > $this->_currentPriority ) {
 return false;
 } $time = strftime('%b %d %H:%M:%S');
 $message = var_export($variable,true);
 return fwrite($this->_fp,
 sprintf("%s %s [%s] variable %s = %s rn",
 $time,
 $this->_logger_name,
 $this->priorities[$priority],
 $name,
 $message)
 );
} function info($message) {
 return $this->log($message, ABC_INFO);
} function debug($message) {
 return $this->log($message, ABC_DEBUG);
} function notice($message) {
 return $this->log($message, ABC_NOTICE);
} function warning($message) {
 return $this->log($message, ABC_WARNING);
} function trace($message) {
 return $this->log($message, ABC_TRACE);
} function error($message) {
 return $this->log($message, ABC_ERROR);
}
function _writeLine($message, $priority, $time) {
 if( fwrite($this->_fp, sprintf("%s %s [%s] %srn", $time, $this->_logger_name, $this->priorities[$priority], $message)) ) {
 return fflush($this->_fp);
 } else {
 return false;
 } } function _openfile() {
 if (($this->_fp = @fopen($this->_filename, 'a')) == false) {
 return false;
 } return true;
} function close(){
 if($this->_currentPriority != ABC_NO_LOG){
 $this->info("Logger stoped");
 return fclose($this->_fp);
 } }
function Factory($name, $logger_name, $level) {
 $instance = new DebugOut($name, $logger_name, $level);
 return $instance;
} function &getWriterSingleton($name, $logger_name, $level = ABC_DEBUG){
 static $instances;
 if (!isset($instances)){
 $instances = array();
 } $signature = serialize(array($name, $level));
 if (!isset($instances[$signature])) {
 $instances[$signature] = DebugOut::Factory($name, $logger_name, $level);
 }
 return $instances[$signature];
} function attach(&$logObserver) {
 if (!is_object($logObserver)) {
 return false;
 } $logObserver->_listenerID = uniqid(rand());
 $this->_listeners[$logObserver->_listenerID] = &$logObserver;
}}define ('ABC_BAD_DATE', -1);
class ExcelDateUtil{
function xls2tstamp($date) {
$date=$date>25568?$date:25569;
 $ofs=(70 * 365 + 17+2) * 86400;
 return ($date * 86400) - $ofs;
}function getDateArray($xls_date){
 $ret = array();
 if ($xls_date == 60) {
 $ret['day'] = 29;
 $ret['month'] = 2;
 $ret['year'] = 1900;
 return $ret;
 } else if ($xls_date $xls_date++;
 }
 $l = $xls_date + 68569 + 2415019;
 $n = (int)(( 4 * $l ) / 146097);
 $l = $l - (int)(( 146097 * $n + 3 ) / 4);
 $i = (int)(( 4000 * ( $l + 1 ) ) / 1461001);
 $l = $l - (int)(( 1461 * $i ) / 4) + 31;
 $j = (int)(( 80 * $l ) / 2447);
 $ret['day'] = $l - (int)(( 2447 * $j ) / 80);
 $l = (int)($j / 11);
 $ret['month'] = $j + 2 - ( 12 * $l );
 $ret['year'] = 100 * ( $n - 49 ) + $i + $l;
 return $ret;
}function isInternalDateFormat($format) {
 $retval =false;
 switch(format) {
 case 0x0e:
 case 0x0f:
 case 0x10:
 case 0x11:
 case 0x12:
 case 0x13:
 case 0x14:
 case 0x15:
 case 0x16:
 case 0x2d:
 case 0x2e:
 case 0x2f:
 case 0xa4:
 case 0xa5:
 case 0xa6:
 case 0xa7:
 case 0xa8:
 case 0xa9:
 case 0xaa:
 case 0xab:
 case 0xac:
 case 0xad:
 $retval = true; break;
 default: $retval = false; break;
 } return $retval;
}}define('EXCEL_FONT_RID',0x31);
define('XF_SCRIPT_NONE',0);
define('XF_SCRIPT_SUPERSCRIPT',1);
define('XF_SCRIPT_SUBSCRIPT',2);
define('XF_UNDERLINE_NONE',0x0);
define('XF_UNDERLINE_SINGLE',0x1);
define('XF_UNDERLINE_DOUBLE',0x2);
define('XF_UNDERLINE_SINGLE_ACCOUNTING',0x3);
define('XF_UNDERLINE_DOUBLE_ACCOUNTING',0x4);
define('XF_STYLE_ITALIC', 0x2);
define('XF_STYLE_STRIKEOUT', 0x8);
define('XF_BOLDNESS_REGULAR',0x190);
define('XF_BOLDNESS_BOLD',0x2BC);
class ExcelFont {
function basicFontRecord() {
 return array('size' => 10,
 'script' => XF_SCRIPT_NONE,
 'undeline' => XF_UNDERLINE_NONE,
 'italic' => false,
 'strikeout'=> false,
 'bold' => false,
 'boldness' => XF_BOLDNESS_REGULAR,
 'palete' => 0,
 'name' => 'Arial');
} function getFontRecord(&$wb,$ptr) {
 $retval = array('size' => 0,
 'script' => XF_SCRIPT_NONE,
 'undeline' => XF_UNDERLINE_NONE,
 'italic' => false,
 'strikeout'=> false,
 'bold' => false,
 'boldness' => XF_BOLDNESS_REGULAR,
 'palete' => 0,
 'name' => '');
 $retval['size'] = (ord($wb[$ptr])+ 256*ord($wb[$ptr+1]))/20;
 $style=ord($wb[$ptr+2]);
 if (($style & XF_STYLE_ITALIC) != 0) {
 $retval['italic'] = true;
 } if (($style & XF_STYLE_STRIKEOUT) != 0) {
 $retval['strikeout'] = true;
 } $retval['palete'] = ord($wb[$ptr+4])+256*ord($wb[$ptr+5]);
 $retval['boldness'] = ord($wb[$ptr+6])+256*ord($wb[$ptr+7]);
 $retval['bold'] = $retval['boldness'] == XF_BOLDNESS_REGULAR ? false:true;
 $retval['script'] = ord($wb[$ptr+8])+256*ord($wb[$ptr+9]);
 $retval['underline'] = ord($wb[$ptr+10]);
 $length = ord($wb[$ptr+14]);
 if($length >0) {
 if(ord($wb[$ptr+15]) == 0) {
 $retval['name'] = substr($wb,$ptr+16,$length);
 } else {
 $retval['name'] = ExcelFont::getUnicodeString($wb,$ptr+15,$length);
 } } return $retval;
} function toString(&$record,$index) {
 $retval = sprintf("Font Index = %d nFont Size =%dnItalic = %snStrikeoout=%snPalete=%snBoldness = %s Bold=%sn Script = %dn Underline = %dn FontName=%s

",
                $index,
                $record['size'],
                $record['italic']    == true?"true":"false",
                $record['strikeout'] == true?"true":"false",
                $record['palete'],
                $record['boldness'],
                $record['bold'] == true?"true":"false",
                $record['script'],
                $record['underline'],
                $record['name']
                );
    return $retval;
} function getUnicodeString(&$string,$offset,$length) {
        $bstring = "";
        $index   = $offset + 1;
        for ($k = 0; $k         {
            $bstring = $bstring.$string[$index];
            $index        += 2;
        }        return substr($bstring,0,$length);
} function ExcelToCSS($rec, $app_font=true, $app_size=true, $app_italic=true, $app_bold=true){
    $ret = "";
    if($app_font==true){
        $ret = $ret."font-family:".$rec['name']."; ";
    }    if($app_size==true){
        $ret = $ret."font-size:".$rec['size']."pt; ";
    }    if($app_bold==true){
        if($rec['bold']==true){
            $ret = $ret."font-weight:bold; ";
        } else {
            $ret = $ret."font-weight:normal; ";
        }    }    if($app_italic==true){
        if($rec['italic']==true){
            $ret = $ret."font-style:italic; ";
        } else {
            $ret = $ret."font-style:normal; ";
        }    }    return $ret;
}}define ( DP_EMPTY, 0 );
define ( DP_STRING_SOURCE, 1 );
define ( DP_FILE_SOURCE, 2 );
class ExcelParserUtil
{
function str2long($str) {
return ord($str[0]) + 256*(ord($str[1]) +
256*(ord($str[2]) + 256*(ord($str[3])) ));
}}
class DataProvider
{
function DataProvider( $data, $dataType )
{
switch( $dataType )
{
case DP_FILE_SOURCE:
if( !( $this->_data = @fopen( $data, "rb" )) )
return;
$this->_size = @filesize( $data );
if( !$this->_size )
_die("Failed to determine file size.");
break;
case DP_STRING_SOURCE:
$this->_data = $data;
$this->_size = strlen( $data );
break;
default:
_die("Invalid data type provided.");
}$this->_type = $dataType;
register_shutdown_function( array( $this, "close") );
}function get( $offset, $length )
{
if( !$this->isValid() )
_die("Data provider is empty.");
if( $this->_baseOfs + $offset + $length > $this->_size )
_die("Invalid offset/length.");
switch( $this->_type )
{
case DP_FILE_SOURCE:
{
if( @fseek( $this->_data, $this->_baseOfs + $offset, SEEK_SET ) == -1 )
_die("Failed to seek file position specified by offest.");
return @fread( $this->_data, $length );
}case DP_STRING_SOURCE:
{
$rc = substr( $this->_data, $this->_baseOfs + $offset, $length );
return $rc;
}default:
_die("Invalid data type or class was not initialized.");
}}function getByte( $offset )
{
return $this->get( $offset, 1 );
}function getOrd( $offset )
{
return ord( $this->getByte( $offset ) );
}function getLong( $offset )
{
$str = $this->get( $offset, 4 );
return ExcelParserUtil::str2long( $str );
}function getSize()
{
if( !$this->isValid() )
_die("Data provider is empty.");
return $this->_size;
}function getBlocks()
{
if( !$this->isValid() )
_die("Data provider is empty.");
return (int)(($this->_size - 1) / 0x200) - 1;
}function ReadFromFat( $chain, $gran = 0x200 )
{
$rc = '';
for( $i = 0; $i $rc .= $this->get( $chain[$i] * $gran, $gran );
return $rc;
}function close()
{
switch($this->_type )
{
case DP_FILE_SOURCE:
@fclose( $this->_data );
case DP_STRING_SOURCE:
$this->_data = null;
default:
$_type = DP_EMPTY;
break;
}}function isValid()
{
return $this->_type != DP_EMPTY;
}var $_type = DP_EMPTY;
var $_data = null;
var $_size = -1;
var $_baseOfs = 0;
}class ExcelFileParser {
var $dp = null;
var $max_blocks;
var $max_sblocks;
var $fat;
var $sfat;
var $formats;
var $xf;
var $fonts;
    var $dbglog;

Kenyataan：

Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn

Artikel sebelumnya：SSI使用详解_PHP教程Artikel seterusnya：PHP MySQL实现无限级分类|树型显示分类关系_PHP教程

Artikel berkaitan

Lihat lagi