Breaking News: Grepper is joining You.com. Read the official announcement!

how can we export larage data from table in laravel 8

Tyagi420 answered on July 22, 2022 Popularity 9/10 Helpfulness 1/10

answer how can we export larage data from table in laravel 8

related export table laravel

how can we export larage data from table in laravel 8

Comment

 $columns = [
            'S. NO',
            'IFSC CODE',
            'BANK NAME',
            'BRANCH NAME',
            'BRANCH ADDRESS',
            'BRANCH PINCODE',
            'BRANCH AREA 1',
            'BRANCH AREA 2',
            'BRANCH STATE',
            'CREATED AT',
            'UPDATED AT',
        ];

// create csv
        return response()->streamDownload(function () use ($columns) {
            $file = fopen('php://output', 'w+');
            fputxlsx($file, $columns);

            $data = IfscMaster::select(
                'id',
                'ifs_code',
                'bank_name',
                'branch_name',
                'branch_address',
                'branch_pincode',
                'branch_area1',
                'branch_area2',
                'branch_state',
                'created_at',
                'updated_at',
            )
                ->orderBy('id', 'desc');

            $data = $data->cursor()
                ->each(function ($data) use ($file) {
                    $data = $data->toArray();
                    fputcsv($file, $data);
                });

            fclose($file);
        }, 'AllUsersCSV' . date('d-m-Y') . '.xlsx');
        die;

Popularity 9/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: export laravel-8 php

Link to this answer
Share Copy Link

Contributed on Jul 22 2022

Tyagi420

0 Answers Avg Quality 2/10

Closely Related Answers

export table laravel

Comment

use Rap2hpoutre\FastExcel\FastExcel;
composer require rap2hpoutre/fast-excel
  
  <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use Rap2hpoutre\FastExcel\FastExcel;//Ensure to import the class
use App\User;
class excelExportController extends Controller
{

   public function index()
   {
  // Load users
  ＄users = User::all();

  // Export all users
  (new FastExcel(＄users))->export('file.xlsx');
  }
}

Popularity 8/10 Helpfulness 2/10 Language php

Source: Grepper

Tags: export laravel lar

Link to this answer
Share Copy Link

Contributed on Jul 15 2023

DB ms

0 Answers Avg Quality 2/10

how can we export larage data from table in laravel 8

Contents

More Related Answers

how can we export larage data from table in laravel 8

Closely Related Answers

export table laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.