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

pack("VV", 0, ($rknum & 0xfffffffc)));
// //$value = $tmp[''''];
// if (array_key_exists(1, $tmp)) {
// $value = $tmp;
// } else {
// $value = $tmp[''''];
// }
// I got my info on IEEE754 encoding from
// http://research.microsoft.com/~hollasch/cgindex/coding/ieeefloat.html
// The RK format calls for using only the most significant 30 bits of the
// 64 bit floating point value. The other 34 bits are assumed to be 0
// So, we use the upper 30 bits of $rknum as follows...
$sign = ($rknum & 0x80000000) >> 31;
$exp = ($rknum & 0x7ff00000) >> 20;
$mantissa = (0x100000 | ($rknum & 0x000ffffc));
$value = $mantissa / pow( 2 , (20- ($exp - 1023)));
if ($sign) {$value = -1 * $value;}
//end of changes by mmp
}
if (($rknum & 0x01) != 0) {
$value /= 100;
}
return $value;
}
function _encodeUTF16($string)
{
$result = $string;
if ($this->_defaultEncoding){
switch ($this->_encoderFunction){
case ''iconv'' : $result = iconv(''UTF-16LE'', $this->_defaultEncoding, $string);
break;
case ''mb_convert_encoding'' : $result = mb_convert_encoding($string, $this->_defaultEncoding, ''UTF-16LE'' );
break;
}
}
return $result;
}
function _GetInt4d($data, $pos)
{
$value = ord($data[$pos]) | (ord($data[$pos+1]) << 8) | (ord($data[$pos+2]) << 16) | (ord($data[$pos+3]) << 24);
if ($value>=4294967294)
{
$value=-2;
}
return $value;
}
}
/*
* Local variables:
* tab-width: 4
* c-basic-offset: 4
* c-hanging-comment-ender-p: nil
* End:
*/
?>

2、调用方法
复制代码 代码如下:
<?php
$data = new ReadexcelSystem();
$data->setOutputEncoding(''utf-8'');
$data->read($location);
print_r($data->sheets[0][''cells''] );
?>
$data->sheets[0][''cells'']

就是我们要获取的excle文件里的数据