Advertisement

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)

还没有任何评论哟~