php导入excel经典实例_PHP教程
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']
推荐阅读
-
CodeIgniter配置之routes.php用法实例分析,codeigniterroutes_PHP教程
-
ThinkPHP模板循环输出Volist标签用法实例详解,thinkphpvolist_PHP教程
-
php实现的发送带附件邮件类实例,附件实例_PHP教程
-
在Nginx上部署ThinkPHP项目教程_php实例
-
高性能PHP框架Symfony2经典入门教程,symfony2入门教程_PHP教程
-
Drupal读取Excel并导入数据库实例_php实例
-
php文件缓存类实例整理_PHP教程
-
php 判断访问者是否手机客户端实例_PHP教程
-
php树形结构数据存取实例类_PHP教程
-
简单的php查询数据库语句实例代码_PHP教程