我们在这篇文章中为大家详细介绍了一些有关PHP读取Excel文件类的相关用法,
希望对正在学习PHP语言的新手们有些帮助,提高大家对PHP的理解程度。

PHP读取Excel文件类代码示例:

< ?php
require_once '../Excel/reader.php';
// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();
// Set output Encoding.指定中文码
$data->setOutputEncoding('gb2312');

/***
* if you want you can change 'iconv'
to mb_convert_encoding:
* $data->setUTFEncoder('mb');
*
**/
/***
* By default rows & cols indeces start with 1
* For change initial index use:
* $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)
*
**/
// 指定读取的excel文件
$data->read('../uploads/jsxz01.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);
// 循环读取每一个单元值
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 "<br>";
}
//print_r($data);
//print_r($data->formatRecords);
?>
以上就是PHP读取Excel文件类的全部用法,作为一个参考对象。

发表评论

电子邮件地址不会被公开。 必填项已用*标注