PHP打开CSV文件

PHP打开CSV文件

1. //设置UTF-8编码
2. setlocale(LC_ALL, 'en_US.UTF-8');
3. //csv路径
4. $csv_file = "csv/excel.csv";
5. //以只读方式打开文件
6. $handle = fopen($csv_file, "r");
7. //定义结果数组
8. $listarr = array();
9. //打开csv中一行,并用","分割为数组
10. while($data = fgetcsv($handle, 1000, ",")){
11. $num = count($data);
12. for($i=0; $i $data[$i] = mb_convert_encoding($data[$i],"UTF-8","UTF-8");
13. }
14. $listarr[] = $data;
15. }
17. return $listarr;

复制代码