Export Excel

<button id="exportButton" class="btn btn-primary mb-3">Export to Excel</button>
<table id="exportDataTable" class="table">
<script src="https://cdn.jsdelivr.net/npm/xlsx/dist/xlsx.full.min.js"></script>
<script>
  document.getElementById('exportButton').addEventListener('click', function () {
    var table = document.getElementById('exportDataTable');
    var workbook = XLSX.utils.table_to_book(table, {sheet: "Sheet JS"});
    XLSX.writeFile(workbook, 'table_data.xlsx');
  });
</script>
--------------------------------------------------------------------------------

composer require maatwebsite/excel
composer require maatwebsite/excel:^3.1
composer require maatwebsite/excel --ignore-platform-req=ext-zip
   
config/app.php       
'providers' => [
    // ...
    Maatwebsite\Excel\ExcelServiceProvider::class,
],

'aliases' => [
    // ...
    'Excel' => Maatwebsite\Excel\Facades\Excel::class,
],

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" --tag=config

Export--------------------------------------------------------
php artisan make:export UserExport --model=User

app/exports/UserExport.php
<?php
namespace App\Exports;

use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class StudentsExport implements FromCollection, WithHeadings
{
    public function collection(){
        return User::select('id', 'name', 'email')->get();
    }

public function headings(): array{
        return [ '#', 'Name', 'Email'];
    }
}

UserController.php        
use App\Exports\UserExport;
use Maatwebsite\Excel\Facades\Excel;

public function user_export(){
    return Excel::download(new UserExport, 'users.xlsx');
}
web.php
Route::get('/user_export', [UserController::class, 'user_export']);

Import--------------------------------------------------------
php artisan make:import UserImport --model=User

app/imports/UserImport.php
use Maatwebsite\Excel\Concerns\WithHeadingRow;
class UsersImport implements ToModel, WithHeadingRow
{
    public function model(array $row){
        return new User([
            'name'     => $row['name'],
            'email'    => $row['email'], 
        ]);
    }
}

UserController.php        
use App\Imports\UserImport;
use Maatwebsite\Excel\Facades\Excel;

public function user_import() {
    Excel::import(new UserImport,request()->file('file')); 
    return back();
}
web.php
Route::post('/user_import', [BlogController::class, 'user_import']);
            
<form action="{{ url('/user_import') }}" method="POST" enctype="multipart/form-data"> @csrf
  <div class="input-group mb-3">
    <input type="file" name="file" class="form-control" placeholder="" aria-label="Example text with button addon" aria-describedby="button-addon1">
    <button class="btn btn-dark" type="submit" id="button-addon1">Import</button>
  </div>
</form>
---------------------------------------------------------------------

https://www.itsolutionstuff.com/post/laravel-9-import-export-excel-and-csv-file-tutorialexample.html
          
composer require maatwebsite/excel
composer require maatwebsite/excel:*
composer.json
"maatwebsite/excel": "3.1.48",
composer update

app.php
providers 
Maatwebsite\Excel\ExcelServiceProvider::class,
aliases 
'Excel' =>Maatwebsite\Excel\Facades\Excel::class,
composer dump-autoload

BlogController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\Blog;
use Maatwebsite\Excel\Facades\Excel;
use App\Exports\BlogsExport;
use PDF;

class BlogController extends Controller
{
    public function index(){
        $all_data = Blog::select('*')->orderBy('id', 'DESC')->get();                                                   
        return view('welcome',compact('all_data'));
    } 
    public function export(){                                               
        return Excel::download(new BlogsExport, 'bulkData.xlsx');
    } 
}

app.Exports.BlogsExport.php
<?php
namespace App\Exports;
use App\Models\Blog;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithHeadings;

class BlogsExport implements FromQuery,WithHeadings{
    public function headings(): array{
        return [
            'Id',
            'Title',
            'Detail',
            'CreatedAt',
            'UpdatedAt',
        ];
    }
    public function query(){
        return Blog::query();
    }
    public function map($bulk):array{
        return [
            $bulk->id,
            $bulk->title,
            $bulk->detail,
            Date::dateTimeToExcel($bulk->created_at),
            Date::dateTimeToExcel($bulk->updated_at),
        ];
    }
}

?>
---------------------------------------------------------------
<a href="{{url('/free_mcq_questions_export',$free_mcq->id)}}" class="btn btn-dark">Export</a>
Route::get('/free_mcq_questions_export/{free_mcq_id}', [FreeMcqQuestionController::class, 'free_mcq_questions_export']);

public function free_mcq_questions_export($free_mcq_id){
        return Excel::download(new FreeMcqQuestionExport($free_mcq_id), 'questions.xlsx');
    }

use Illuminate\Support\Collection;
{
    protected $free_mcq_id;

public function __construct($free_mcq_id){
        $this->free_mcq_id = $free_mcq_id;
    }
    public function collection()
    {
        return FreeMcqQuestion::where('free_mcq_id', $this->free_mcq_id)->select('id','free_mcq_id','question','option1','option2','option3','option4','answer','explanation')->get();
        // return FreeMcqQuestion::all();
    }
    public function headings(): array{
        return [
            'ID',
            'Free_Mcq_Id',
            'Question',
            'Option1',
            'Option2',
            'Option3',
            'Option4',
            'Answer',
            'Explanation',
        ];
    }
}
------------------------------------------------------------------