Laravel excel，为什么函数（$ reader）无法获取变量？

Question

Currently im using Laravel-Excel(MaatWebsite). I have codes like this in controller

public function house($id)
{
  $furniture_number = Furniture::where('id', $id)->first();

  $rows = Excel::load('storage\\app\\public\\upload\\furniture.xlsx', function($reader)
  {
    $reader->noHeading(); 
    $reader->takeColumns($furniture_number->amount);
  })->get();
}

The dd($furniture_number->amount) return "10"

Undefined variable: furniture_number (at the $reader->takeColumns($furniture_number->amount); line)

Answer 1

You need to pass the $furniture_number variable to the closure with the 'use' statement:

  $rows = Excel::load('storage\\app\\public\\upload\\furniture.xlsx', function($reader) use ($furniture_number) {
    $reader->noHeading(); 
    $reader->takeColumns($furniture_number->amount);
  })->get();