PHP中Excel的导入导出

<? 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] <= 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 "<code>\n"; $cs = debug_backtrace(); for( $i = 1; $i < count($cs) ; $i++ ) { $item = $cs[ $i ]; for( $j = 0; $j < count($item['args']); $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 . "<br>\n"; } print "</code>\n"; } function _die( $str ) { print "Script died with reason: $str<br>\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(); } /*Destructor Registering*/ register_shutdown_function(array($this,"close")); } function log($message, $priority = ABC_INFO) { // Abort early if the priority is above the maximum logging level. if ($priority > $this->_currentPriority) { return false; } // Add to loglines array 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 \r\n", $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); } /** * Writes a line to the logfile * * @param string $line The line to write * @param integer $priority The priority of this line/msg * @return integer Number of bytes written or -1 on error * @access private */ function _writeLine($message, $priority, $time) { if( fwrite($this->_fp, sprintf("%s %s [%s] %s\r\n", $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); } } /* * Managerial Functions. * */ 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 { /* * return 1900 Date as integer TIMESTAMP. * for UNIX date must be * */ function xls2tstamp($date) { $date=$date>25568?$date:25569; /*There was a bug if Converting date before 1-1-1970 (tstamp 0)*/ $ofs=(70 * 365 + 17+2) * 86400; return ($date * 86400) - $ofs; } function getDateArray($xls_date) { //echo "ddddddd= ".$xls_date; $ret = array(); // leap year bug if ($xls_date == 60) { $ret['day'] = 29; $ret['month'] = 2; $ret['year'] = 1900; return $ret; }else if ($xls_date < 60) { // 29-02-1900 bug $xls_date++; } // Modified Julian to DMY calculation with an addition of 2415019 $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 +