PHP使用phpexcel读取excel文件

PHP读取excel文件require("Classes/PHPExcel.php");

require("Classes/PHPExcel/IOFactory.php");

require("Classes/PHPExcel/Reader/Excel5.php");

require("Classes/PHPExcel/Reader/Excel.php");

$filePath = "text.xls" ;

$PHPExcel = new PHPExcel() ;$PHPReader = new PHPExcel_Reader_Excel();if(!$PHPReader->canRead($filePath)){$PHPReader = new PHPExcel_Reader_Excel5();if(!$PHPReader->canRead($filePath)){return false;}}//读取excel$PHPExcel = $PHPReader->load($filePath);//获取工作表的数目$sheetCount = $PHPExcel->getSheetCount();$sheet = 0 ;$currentSheet = $PHPExcel->getSheet($sheet);$allRow = $currentSheet->getHighestRow(); //获取Excel中信息的行数$allColumn = $currentSheet->getHighestColumn();//获取Excel的列数$objWorksheet = $PHPExcel->getActiveSheet();$highestRow = $objWorksheet->getHighestRow(); //有效总行数$highestColumnIndex = $objWorksheet->getHighestColumn();$highestColumn = PHPExcel_Cell::columnIndexFromString($highestColumnIndex);//有效总列数//获取表格值$data = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() ;

如果觉得《PHP使用phpexcel读取excel文件》对你有帮助，请点赞、收藏，并留下你的观点哦！