首页 > 代码库 > php读取excel文件数据
php读取excel文件数据
require_once $_SERVER[‘DOCUMENT_ROOT‘].‘/Classes/PHPExcel.php‘;
require_once $_SERVER[‘DOCUMENT_ROOT‘].‘/Classes/PHPExcel/IOFactory.php‘;
function getReadExcel($uploadfile,$time){
$extension = substr($uploadfile,strrpos($uploadfile,‘.‘)+1);
switch ($extension){
case ‘xlsx‘:{
$objReader = PHPExcel_IOFactory::createReader(‘Excel2007‘);/*excel2007 for 2007*/
}break;
case ‘xls‘:{
$objReader = PHPExcel_IOFactory::createReader(‘Excel5‘);/*Excel5 for 2003*/
}break;
case ‘csv‘:{
$objReader = PHPExcel_IOFactory::createReader(‘CSV‘);/*Csv for csv*/
}break;
}
$objPHPExcel = $objReader->load($uploadfile); //Excel 路径
$sheet = $objPHPExcel->getSheet(0);
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);//总列数
for ($row = 1;$row <= $highestRow;$row++){
$strs=array();
//注意highestColumnIndex的列数索引从0开始
for ($col = 0;$col < $highestColumnIndex;$col++){
$strs[$col] = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
if($extension == ‘csv‘){
$strs[$col] = iconv(‘gbk‘, ‘utf-8‘, $strs[$col]);
}
}
$data[] = $strs;
}
return $data;
}
php读取excel文件数据
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。