excel表格式:
代码:
???????????$objPHPExcel=PHPExcel_IOFactory::load($excelFilePath);//$file_url即Excel文件的路径 ???????????$sheet=$objPHPExcel->getSheet(0);//获取第一个工作表 ???????????$highestRow=$sheet->getHighestRow();//取得总行数 ???????????$highestColumn=$sheet->getHighestColumn(); //取得总列数 ???????????$ChangeDatas = []; ???????????for($j=2;$j<=$highestRow;$j++){ ???????????????$str=‘‘; ???????????????for($k=‘A‘;$k<=$highestColumn;$k++){ ???????????????????$str.=$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue().‘\\‘; ???????????????} ???????????????//explode:函数把字符串分割为数组。 ???????????????$strs=explode("\\",$str); ???????????????array_pop($strs); ???????????????array_push($ChangeDatas, $strs); ???????????} ???????????var_dump($ChangeDatas);
phpexcel获取excel表格内容
原文地址:https://www.cnblogs.com/foreversun/p/8335040.html