php导入excel经典实例

php教程导入excel经典实例

require_once 'excel/reader.php';

// excelfile($filename, $encoding);
$data = new spreadsheet_excel_reader();

// set output encoding.
$data->setoutputencoding('cp1251');

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

error_reporting(e_all ^ e_notice);

for ($i = 1; $i sheets[0]['numrows']; $i++) {
for ($j = 1; $j sheets[0]['numcols']; $j++) {
echo """.$data->sheets[0]['cells'][$i][$j]."",";
}
echo "n";

}

格式化输出格式

/***
* 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->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']