duan5362 2014-11-24 11:58
浏览 25
已采纳

使用PHP如何转换csv文件

i have a csv file where the header line is in row 1 not row 0 how can i convert a csv in this situation. I have seen good versions of converting a csv file where the header row is at row[0] as

function csv_to_array($filename='', $delimiter=',')
{
if(!file_exists($filename) || !is_readable($filename))
    return FALSE;

$header = NULL;
$data = array();
if (($handle = fopen($filename, 'r')) !== FALSE)
{
    while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE)
    {
        if(!$header)
            $header = $row;
        else
            $data[] = array_combine($header, $row);
    }
    fclose($handle);
}
return $data;
}

please can someone assist me in the situation where row[1] is the header row.

  • 写回答

3条回答 默认 最新

  • doqs8936 2014-11-24 12:14
    关注

    You can do like this :

                function csv_to_array($filename='', $delimiter=',')
                {
                if(!file_exists($filename) || !is_readable($filename))
                    return FALSE;
    
                $header = NULL;
                $data = array();
                if (($handle = fopen($filename, 'r')) !== FALSE)
                {
                    $i=0;
                    while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE)
                    {
                        if($i==0)
                        {
                          $i++;
                          continue;   //SKIP FIRST ROW
                        }
                        if(!$header)
                            $header = $row;
                        else
                            $data[] = array_combine($header, $row);
                    }
                    fclose($handle);
                }
                return $data;
                }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 孟德尔随机化结果不一致
  • ¥15 深度学习残差模块模型
  • ¥50 怎么判断同步时序逻辑电路和异步时序逻辑电路
  • ¥15 差动电流二次谐波的含量Matlab计算
  • ¥15 Can/caned 总线错误问题,错误显示控制器要发1,结果总线检测到0
  • ¥15 C#如何调用串口数据
  • ¥15 MATLAB与单片机串口通信
  • ¥15 L76k模块的GPS的使用
  • ¥15 请帮我看一看数电项目如何设计
  • ¥23 (标签-bug|关键词-密码错误加密)