php 上传文件并读取 excel/csv 文件中的单元格内容
发布时间
阅读量:
阅读量
一、利用PHPExcel实现对csv文件及excel文件(.xlsx格式)的读取操作
https://github.com/PHPOffice/PHPExcel
$filePath = 'example.xlsx';
$inputFileType = \PHPExcel_IOFactory::identify($filePath);
$objReader = \PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($filePath);
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$list = [];
for ($column = "A"; $column <= $highestColumn; $column++) {
for ($row = 2; $row <= $highestRow; $row++) {
$cel
全部评论 (0)
还没有任何评论哟~
