php 导入excel电子表文件
作者:阿圣(Sfan) 发布于:2009-4-28 22:44 Tuesday 分类:Web
php 导入excel电子表文件,在单位编写导入excel文件时,原来是把excel文件转为cvs文件,在编写php程序导入。
- <?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
« 关于网上邻居 属性 菜单
|
ICBC»
评论:
2009-04-29 12:16