//读取csv文件
$file_path = "Uploads/201911/5dbb7ef58f1ae.csv";
$filecsv = fopen($file_path, 'r'); //打开文件
stream_filter_append($filecsv, "convert.iconv.gbk/utf-8"); //ANSI格式的CSV文件到UTF-8格式读取
while (!feof($filecsv)) {
    $csvData[] = (fgetcsv($filecsv));}
fclose($filecsv); //关闭读取文件
unset($csvData[0]); //模拟删除第一行(如果有表头的话)
echo "<pre>";print_r($csvData);echo "</pre>";

//读取xls或xlsx文件
$excel_file_name = "Uploads/201910/5d9ee5a4ae683.xls";
vendor("PHPExcel.PHPExcel");
$extension = strtolower(pathinfo($excel_file_name, PATHINFO_EXTENSION));
if ($extension == 'xlsx') {
    $objReader = \PHPExcel_IOFactory::createReader('Excel2007');
    $objPHPExcel = $objReader->load($excel_file_name, $encode = 'utf-8');
} elseif ($extension == 'xls') {
    $objReader = \PHPExcel_IOFactory::createReader('Excel5');
    $objPHPExcel = $objReader->load($excel_file_name, $encode = 'utf-8');
}
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$i = 0;
$hi = 7; //第几行开始
for ($i = $hi; $i <= $highestRow; $i++) {
    $ii = $i - 1;
    $row_a = $objPHPExcel->getActiveSheet()->getCell("A" . $i)->getValue();
    $row_b = $objPHPExcel->getActiveSheet()->getCell("B" . $i)->getValue();
    $row_c = $objPHPExcel->getActiveSheet()->getCell("C" . $i)->getValue();
    $row_d = $objPHPExcel->getActiveSheet()->getCell("D" . $i)->getValue();
    echo "{$row_a}>{$row_b}>{$row_c}>{$row_d}><br>";
}