Select columns in different variables Laravel Excel

Question

I use Laravel Excel and I want to load columns separately, like this:

$rows = Excel::selectSheetsByIndex(0)->load($fileName);
$a = $rows->select($column1)->get();
$b = $rows->select($column2)->get();

Where $column1 and column2 are array with the names of columns I want to get.

In my $a i have the column1 but in my $b I have the column1 AND the column2. How to just have the column2 in $b without realoding the Excel file?

EDIT : The solution is to replace:

$a = $rows->select($column1)->get();

by :

$a = $rows->get($column1);

From where $column1 and $column2 are coming, I think, you wrote incomplete snippet here. — Rahul, Jan 31 '17 at 09:27
It's an example here, supposing they are the names of columns I want — K4tn1x, Jan 31 '17 at 09:29
Is this one http://www.maatwebsite.nl/laravel-excel/docs/export you are using ? — Rahul, Jan 31 '17 at 09:31
Yes but here is import : http://www.maatwebsite.nl/laravel-excel/docs/import — K4tn1x, Jan 31 '17 at 09:33
$a = $reader->select(array('col1'))->get(); $b = $reader->select(array('col2'))->get(); have you tried like this ?? — Rahul, Jan 31 '17 at 09:50

score 0 · Accepted Answer · answered Jan 31 '17 at 11:10

0

I think you should try this:

$rows = Excel::selectSheetsByIndex(0)->load($fileName);
$a = $rows->get(array('firstname'));
$b = $rows->get(array('lastname'));

Note: firstname and lastname field is your column name

Hope this work for you!

answered Jan 31 '17 at 11:10

Thanks it works perfectly, I thought the result would be the same with get but it's not, the documentation is not very clear on that... – K4tn1x Jan 31 '17 at 12:09

1 Answers1