Read a .csv file into an array in Laravel

Question

I have stored a .csv file in this directory in Laravel 5 :

/storage/app/data.csv

Inside of this function I am trying to read the contents of this file and extract a few columns from it, like name and city to an array, sample code:

use Illuminate\Support\Facades\Storage;

public function get_data() {

 $file_n = Storage::url('data.csv');
 $file = fopen($file_n, "r");
 $all_data = array();
 while ( ($data = fgetcsv($file, 200, ",")) !==FALSE {

     $name = $data[0];
     $city = $data[1];
     $all_data = $name. " ".$city;

     array_push($array, $all_data);
  }
  fclose($file);
}

I am getting an ErrorException in Controller:

fopen(/storage/data.csv): failed to open stream: No such file or directory

But the file is there. Is there a better way to do this instead?

Thanks for looking!

If you need to use Storage class for this, specially if you are using s3 or minio, try \Storage::disk('local_temp')->getDriver()->getAdapter()->applyPathPrefix($this->fileName); to get the full file path. This is solution for Laravel 5.1, for Laravel 5.2 and up ::url() function would work. for Laravel 5.7 and up ::path() function would would work. — karmendra
– karmendra, Commented Oct 4, 2019 at 15:40

pableiros · Accepted Answer · 2019-07-06 23:25:02Z

10

I figured it out by using "storage_path".

...
$filename = storage_path('/app/data.csv');
$file = fopen($filename, "r");
$all_data = array();
while ( ($data = fgetcsv($file, 200, ",")) !==FALSE ) {
    ...
}

Thanks!

edited Jul 6, 2019 at 23:25

pableiros

16.2k12 gold badges108 silver badges111 bronze badges

answered Oct 19, 2016 at 18:45

Andre

8494 gold badges16 silver badges32 bronze badges

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

1 Comment

b_dubb Over a year ago

Add use Illuminate\Support\Facades\Storage; to import Storage facade. Then $storagePath = Storage::path($file);

Valkzer · Accepted Answer · 2016-10-19 21:32:01Z

9

Your issue is with the path as previous people pointed out.

You can use the helper function storage_path https://laravel.com/docs/5.3/helpers#method-storage-path

In your case it will be used like this:

storage_path('app/data.csv');

As a recomendation you can use this libary to work with CSV/Excel files, it's pretty easy to use: https://github.com/Maatwebsite/Laravel-Excel

edited Oct 19, 2016 at 21:32

answered Oct 19, 2016 at 21:26

Valkzer

1051 silver badge7 bronze badges

Comments

UserHelpNeeding02356 · Accepted Answer · 2019-02-26 10:59:58Z

7

Laravel 5.7 try this :

Storage::disk('local')->path('import.csv');

It should be good.

answered Feb 26, 2019 at 10:59

UserHelpNeeding02356

2754 silver badges4 bronze badges

Comments

derivative · Accepted Answer · 2017-06-01 19:57:25Z

1

I solved this issue by adding a url key to my local disk config in config/filesystems.php like so:

    'local' => [
        'driver' => 'local',
        'root' => storage_path('app'),
        'url' => storage_path('app')
    ],

Now I can reference Storage::url('filename.txt') and it returns:

    /home/josh/apps/storage/app/filename.txt

edited Jun 1, 2017 at 19:57

answered Jun 1, 2017 at 19:39

derivative

1451 silver badge7 bronze badges

Comments

Jehad Ahmad Jaghoub · Accepted Answer · 2024-03-07 08:08:47Z

1

simply, one line can do it

$csv = array_map('str_getcsv', file(Storage::path('filename.csv')));

answered Mar 7, 2024 at 8:08

Jehad Ahmad Jaghoub

1,40315 silver badges23 bronze badges

Comments

Stephen Rauch · Accepted Answer · 2018-01-27 13:29:09Z

0

Try the below

$file_n = Storage::get('data.csv');

edited Jan 27, 2018 at 13:29

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

answered Jan 27, 2018 at 13:09

Anu Alex

2202 gold badges6 silver badges19 bronze badges

2 Comments

Zero Over a year ago

This returns the csv file as a string.

Md Atiqur Over a year ago

This returns the csv file as a string. – You can avoid this by using $file_path = storage_path('file-name.csv'); $row = array_map("str_getcsv", file($file_path));

Collectives™ on Stack Overflow

Read a .csv file into an array in Laravel

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related