正在为你努力加载中........

点滴记录 分享
23
2014-5
首页 >> php >> php 读取excel文件

php 读取excel文件

php读取excel文件,用的是phpExcelReader, 不过他支持后主是.xls的文件其他的不支持,如果要读取csv文件,可以使用php自带的方法也可以参考另外一篇文章:http://speakphp.com/?post=151

<?php
header("Content-Type:text/html;charset=utf-8");
// Test CVS

require_once 'Excel/reader.php';


// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();


// Set output Encoding.
$data->setOutputEncoding('utf-8');

/***
* if you want you can change 'iconv' to mb_convert_encoding:
* $data->setUTFEncoder('mb');
*
**/
if(function_exists("mb_convert_encoding")){
	$data->setUTFEncoder('mb');
}elseif(function_exists("iconv")){
	$data->setUTFEncoder('iconv');
}

/***
* By default rows & cols indeces start with 1
* For change initial index use:
* $data->setRowColOffset(0);
*
**/

$data->setRowColOffset(0); //设置数组的下标从哪里开始

/***
*  Some function for formatting output.
* $data->setDefaultFormat('%.2f');
* setDefaultFormat - set format for columns with unknown formatting
*
* $data->setColumnFormat(4, '%.3f');
* setColumnFormat - set format for column (apply only to number fields)
*
**/

$data->read('db221.xls');

/*


 $data->sheets[0]['numRows'] - count rows
 $data->sheets[0]['numCols'] - count columns
 $data->sheets[0]['cells'][$i][$j] - data from $i-row $j-column

 $data->sheets[0]['cellsInfo'][$i][$j] - extended info about cell
    
    $data->sheets[0]['cellsInfo'][$i][$j]['type'] = "date" | "number" | "unknown"
        if 'type' == "unknown" - use 'raw' value, because  cell contain value with format '0.00';
    $data->sheets[0]['cellsInfo'][$i][$j]['raw'] = value if cell without format 
    $data->sheets[0]['cellsInfo'][$i][$j]['colspan'] 
    $data->sheets[0]['cellsInfo'][$i][$j]['rowspan'] 
*/

//error_reporting(E_ALL ^ E_NOTICE);
error_reporting(0);
/* for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
	for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
		//echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
	}
	//echo "\n";

} */
echo "<pre>";
print_r($data->sheets[0]['cells']);
//print_r($data->formatRecords);
?>
代码下载地址:phpExcelReader.zip


作者:一根烟的寂寞 分类:php
浏览:3498 评论:2

评论:

屠龙
2014-05-30 16:40
了解了代码的强大作用。
一根烟的寂寞
2014-06-04 16:53
@屠龙:哈哈

发表评论: