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 <= $data->sheets[0]['numrows']; $i++) {
 for ($j = 1; $j <= $data->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']