网站地图
【www.gdgbn.com--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 <= $data->sheets[0]["numrows"]; $i++) {
for ($j = 1; $j <= $data->sheets[0]["numcols"]; $j++) {
echo """.$data->sheets[0]["cells"][$i][$j]."",";
}
echo " ";
}
格式化输出格式
/***
* 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"]