Export search result as excel format

@Sinnbeck This works but save all data from table

public function exportIntoExcel() {
    return Excel::download(new TableExport, 'TableExport.xlsx');
}
public function exportIntoCSV() {
    return Excel::download(new TableExport, 'TableExport.csv');
}

and this is route

Route::get('/export-excel', [MemberController::class,'exportIntoExcel']);
Route::get('/export-csv', [MemberController::class, 'exportIntoCSV']);

now i want to download just searched record based in function i have writed on searchController

@usertxr show the TableExport class

@Sinnbeck i use this on modal TableExport

public static function getTable(){
    $records = DB::table('table_1')->select('id', 'user_id', 'created_at',)->get()->toArray();
    return $records;
  }

@usertxr that does not look like the full class?

@Sinnbeck I select the column from table on TableExport modal and i have done this function on member controller

public function exportIntoExcel() {
return Excel::download(new TableExport, 'TableExport.xlsx');
}
 public function exportIntoCSV() {
return Excel::download(new TableExport, 'TableExport.csv');
}

@usertxr I assume you are using this package? https://docs.laravel-excel.com/3.1/exports/collection.html

You can pass the data through the construct method and just return the result in the collection method https://docs.laravel-excel.com/3.1/exports/collection.html#using-arrays

@Sinnbeck Sorry i dont understant how to pass data throungh construct from my searchController.

@usertxr something like this

$table = \DB::table('table_1');
    if( $request->dtcreated){
        $table = $table->where('created_at', 'LIKE', "%" . $request->dtcreated . "%");
    }
    if( $request->userSearch){
        $table = $table->where('user_id', 'LIKE', '%' . $request->userSearch . '%');
    }

return Excel::download(new CustomExport($table->get()->toArray()), 'TableExport.xlsx');

//class
namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromArray;

class CustomExport implements FromArray
{
    protected $data;

    public function __construct(array $data)
    {
        $this->data = $data;
    }

    public function array(): array
    {
        return $this->data;
    }
} 

@Sinnbeck thanks for this