如何用php转换CSV文件

goqiplq2  于 2022-12-15  发布在  PHP
关注(0)|答案(1)|浏览(115)

我只是想知道我如何显示CSV文件中的数据不同,代码现在有displays the data like this inexcel/google
但我想在excel/google docs like this中显示数据
这是我正在使用的代码,有没有修改它给予我想要的结果?

$data2 = [
  ["number of drinks:" => "1"],
  ["number of snacks:" => "2 "],
  ["number of cats" => "3"],
  ["numbers of dogs:" => "4"],

$fh = fopen('file.csv', 'w');

$headers = [];
$values = [];

foreach ( $data2 as $form_section ) {
    foreach ( $form_section as $heading => $value ) {
        array_push( $headers, $heading );
        array_push( $values, $value );
    }
}

fputcsv( $fh, $headers,);
fputcsv( $fh, $values,);
fclose($fh);
];
cmssoen2

cmssoen21#

这应该会生成传递给fputcsv所需格式的数组。

$data2 = [
  ["number of drinks:" => "1"],
  ["number of snacks:" => "2 "],
  ["number of cats" => "3"],
  ["numbers of dogs:" => "4"],
];

$tmp = [];

$fh = fopen("file.csv", "w");

foreach($data2 as $row){ 
        $header = key($row);
        $value = $row[$header];
        
        fputcsv( $fh, [$header, $value]);
}

fclose($fh);

相关问题