Styjun

Proper way to shut down consumer

How to see the previous "Accessed" date in Windows

My manager quit. Should I agree to defer wage increase to accommodate budget concerns?

Difference between types of yeast

How to create fractional SI units (SI...sqrts)?

Going to France with limited French for a day

How can an attacker use robots.txt?

Is differentiation as a map discontinuous?

Do I have advantage with Riposte when moving away from a flanked enemy and triggering an opportunity attack?

What exactly did this mechanic sabotage on the American Airlines 737, and how dangerous was it?

How can this Stack Exchange site have an animated favicon?

Tesla coil and Tesla tower

Why did UK NHS pay for homeopathic treatments?

Lost Update Understanding

What secular civic space would pioneers build for small frontier towns?

Examples of "unsuccessful" theories with afterlives

Safe to use 220V electric clothes dryer when building has been bridged down to 110V?

Strange Sticky Substance on Digital Camera

Carry vs Roll-Down on a zero-coupon IRS

Should I answer honestly if asked why I was late one day when I was actually in an interview?

Received a package but didn't order it

Is there any relation/leak between two sections of LM358 op-amp?

How to deal with a Homophobic PC

Seeming violation-wave travelling faster than speed of light

Add sheet to existing excel file with Laravel Excel

Laravel Excel - blank sheets when creating multiple sheetsCan't print Excel file valuescharts disappear on running laravel-excelUndefined Laravel path callsUploading excel file LaravelLaravel Excel A1 ErrorUnable to download excel sheet from array using Laravel-Excel?Laravel local storage - file exists but cannot be opend in another classCall to a member function getClientOriginalName() on null when upload image use file system Laravel

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am using Laravel Excel 2.1. I have an array of data that I want to add as a new sheet to an existing excel file and save it locally.

Here is the code I am trying

Excel::load(base_path() . '/storage/app/surveyFilters/' . $surveyFilter->filename, function($file) use($data) 
 $file->sheet('Individuals - Tagged', function($sheet) use($data)
 
 $sheet->fromArray($data);
 );

)->store('xls', public_path('assets')); 

I get this error "Call to a member function fromArray() on null". If I var_dump $data right before the call and exit it shows my array so $data is not null. I also tried with() instead of fromArray() but get similar error message.

Any help would be appreciated.

laravel laravel-excel

share|improve this question

edited Mar 28 at 17:39

Chris

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The error message is saying $sheet is null, not $data
  
  – Derek Pollard
  Mar 28 at 17:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You are correct. $sheet is null. Any idea why $sheet is null? If I comment out $sheet->fromArray($data); it runs fine and puts adds the excel file to the path I give it so it loads the file fine.
  
  – Chris
  Mar 28 at 18:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  From reading the documentation, it appears as though you're trying to add a sheet on an already created file, whereas the documentation only shows that you can do that from a newly created instance from Excel::create()
  
  – Derek Pollard
  Mar 28 at 18:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks. That would explain it as that is what i am trying to do.
  
  – Chris
  Mar 28 at 18:27
  

  
  
  
  

add a comment
 | 

0

I am using Laravel Excel 2.1. I have an array of data that I want to add as a new sheet to an existing excel file and save it locally.

Here is the code I am trying

Excel::load(base_path() . '/storage/app/surveyFilters/' . $surveyFilter->filename, function($file) use($data) 
 $file->sheet('Individuals - Tagged', function($sheet) use($data)
 
 $sheet->fromArray($data);
 );

)->store('xls', public_path('assets')); 

I get this error "Call to a member function fromArray() on null". If I var_dump $data right before the call and exit it shows my array so $data is not null. I also tried with() instead of fromArray() but get similar error message.

Any help would be appreciated.

laravel laravel-excel

share|improve this question

edited Mar 28 at 17:39

Chris

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The error message is saying $sheet is null, not $data
  
  – Derek Pollard
  Mar 28 at 17:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You are correct. $sheet is null. Any idea why $sheet is null? If I comment out $sheet->fromArray($data); it runs fine and puts adds the excel file to the path I give it so it loads the file fine.
  
  – Chris
  Mar 28 at 18:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  From reading the documentation, it appears as though you're trying to add a sheet on an already created file, whereas the documentation only shows that you can do that from a newly created instance from Excel::create()
  
  – Derek Pollard
  Mar 28 at 18:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks. That would explain it as that is what i am trying to do.
  
  – Chris
  Mar 28 at 18:27
  

  
  
  
  

add a comment
 | 

I am using Laravel Excel 2.1. I have an array of data that I want to add as a new sheet to an existing excel file and save it locally.

Here is the code I am trying

Excel::load(base_path() . '/storage/app/surveyFilters/' . $surveyFilter->filename, function($file) use($data) 
 $file->sheet('Individuals - Tagged', function($sheet) use($data)
 
 $sheet->fromArray($data);
 );

)->store('xls', public_path('assets')); 

I get this error "Call to a member function fromArray() on null". If I var_dump $data right before the call and exit it shows my array so $data is not null. I also tried with() instead of fromArray() but get similar error message.

Any help would be appreciated.

laravel laravel-excel

share|improve this question

edited Mar 28 at 17:39

Chris

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges

Excel::load(base_path() . '/storage/app/surveyFilters/' . $surveyFilter->filename, function($file) use($data) 
 $file->sheet('Individuals - Tagged', function($sheet) use($data)
 
 $sheet->fromArray($data);
 );

)->store('xls', public_path('assets')); 

share|improve this question

edited Mar 28 at 17:39

Chris

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges

share|improve this question

edited Mar 28 at 17:39

Chris

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges

asked Mar 28 at 16:22

ChrisChris

30133 silver badges1414 bronze badges