Export Data to CSV or Excel Laravel [duplicate]

Question

I have this Data Array like this

I have stored this value in $data variable

I want to export this data into Excel or CSV

I have tried multiple ways & checked a lot articles but still can't find anything

"I have tried multiple ways & checked a lot articles but still can't find anything" for real? you didnt even stumble upon fputcsv? not even this qa? not even a stroll on packagist? — Bagus Tesa
– Bagus Tesa, Commented Apr 30, 2022 at 13:55

Maik Lowrey · Accepted Answer · 2022-04-30 14:01:03Z

0

You can use plain PHP only without any lib to create csv file. I took a test array for the example below.

The important step is only to convert your array in a comma separated string.

example

<?php

$arr = [
    [
        "id" => 1, "name" => "abc"
    ],
    [
        "id" => 2, "name" => "def"
    ],  
];

$data = [];
foreach($arr as $val) {
    $str = implode(',', $val );
    $data[] = $str;
}

$handle = fopen('export.csv', 'w');

foreach ($data as $row) {
    fputcsv($handle, $row);
}

fclose($handle);

answered Apr 30, 2022 at 14:01

Maik Lowrey

17.8k8 gold badges55 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export Data to CSV or Excel Laravel [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related