Untuk aplikasi web, mengimpor data lembar Excel ke database kami dan mengekspor data dari database ke lembar Excel, merupakan fitur penting. Karena fitur ini, kita dapat dengan mudah melakukan batch import/export data oleh aplikasi web. Sulit di Kerangka lain tetapi paling mudah di laravel 8. Ini memberikan paket Maatwebsite/excel untuk mengimpor/mengekspor data dengan mudah. Pada artikel ini, kita belajar tentang, bagaimana data diekspor dan diimpor
Fitur
- Secara efektif mengirimkan bermacam-macam ke Excel
- Kirim pertanyaan dengan penyambungan terprogram untuk eksekusi yang lebih baik
- Line mengirimkan untuk eksekusi yang lebih baik
- Secara efektif mengirimkan perspektif Blade ke Excel
- Mengimpor secara efektif ke akumulasi
- Baca dengan teliti catatan Excel dalam beberapa bagian
- Tangani penyematan impor dalam rumpun
Langkah-langkah Laravel Impor Ekspor data excel. Kami ingin mengikuti beberapa langkah untuk mengimpor dan mengekspor data dengan mudah. Ada 9 langkah mudah untuk diikuti
- Instal proyek laravel baru
- Konfigurasikan detail dan model Database
- Instal paket maatwebsite/excel
- Buat Rute
- Buat kelas impor untuk mengimpor data
- Buat kelas ekspor untuk mengekspor data
- Buat pengontrol
- Buat file blade / view
- Jalankan proyek laravel
1. Instal proyek laravel baru. Pada langkah pertama, buat proyek laravel baru bernama laravel-excel. Gunakan perintah di bawah ini untuk membuat proyek laravel baru
composer create-project laravel/laravel excel
2. Konfigurasikan detail Database dan buat model. Pada langkah kedua, atur konfigurasi database di. env di laravel 8
PHP
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=8258
DB_DATABASE=laravel
composer require maatwebsite/excel_0
composer require maatwebsite/excel_1
Membuat model. Kemudian buat model baru bernama User model untuk terhubung dengan tabel user di database. Di pengguna, tabel berisi berbagai bidang seperti ID, nama, telepon, dan email
3. Instal Paket maatwebsite/excel. Sekarang, dengan menggunakan komposer kami menginstal nama paket maatwebsite/excel untuk mengekspor dan mengimpor data dengan menggunakan komposer
composer require maatwebsite/excel_
Setelah menginstal paket, kami ingin mendaftarkan layanan plugin di provider dan alias
Kami ingin menulis kode berikut ke dalam file config/app. file php
PHP
composer require maatwebsite/excel_2
composer require maatwebsite/excel3
composer require maatwebsite/excel4
composer require maatwebsite/excel5
composer require maatwebsite/excel6
composer require maatwebsite/excel7
composer require maatwebsite/excel8
composer require maatwebsite/excel9
composer require maatwebsite/excel_3
php artisan make:import ImportUser --model=User1
composer require maatwebsite/excel5
composer require maatwebsite/excel6
php artisan make:import ImportUser --model=User4
php artisan make:import ImportUser --model=User5
composer require maatwebsite/excel6
php artisan make:import ImportUser --model=User7
composer require maatwebsite/excel8
composer require maatwebsite/excel9
php artisan make:export ExportUser --model=User_0
Untuk mempublikasikan konfigurasi di atas, jalankan vendor. mempublikasikan perintah
penjual tukang php. publikasikan –provider=”Maatwebsite\Excel\ExcelServiceProvider” –tag=config
Perintah ini untuk membuat file konfigurasi baru config/excel. php
4. Buat Rute. Kemudian kami membuat rute untuk menangani permintaan dari file impor dan ekspor
PHP
composer require maatwebsite/excel_2
composer require maatwebsite/excel3
php artisan make:export ExportUser --model=User3
php artisan make:export ExportUser --model=User4
composer require maatwebsite/excel3
php artisan make:export ExportUser --model=User6
php artisan make:export ExportUser --model=User7
php artisan make:export ExportUser --model=User8
composer require maatwebsite/excel8
php artisan makes: controller UserController0
php artisan makes: controller UserController1
php artisan makes: controller UserController2
php artisan makes: controller UserController3
php artisan makes: controller UserController4
php artisan makes: controller UserController5
composer require maatwebsite/excel3
php artisan makes: controller UserController7
php artisan makes: controller UserController8
php artisan make:export ExportUser --model=User8
composer require maatwebsite/excel8
php artisan makes: controller UserController0
________32______1
php artisan serve3
php artisan makes: controller UserController3
php artisan serve3
php artisan makes: controller UserController5
composer require maatwebsite/excel3
php artisan make:export ExportUser --model=User6
php artisan serve9
php artisan make:export ExportUser --model=User8
composer require maatwebsite/excel8
php artisan makes: controller UserController0
php artisan makes: controller UserController1
DB_CONNECTION=mysql
4php artisan makes: controller UserController3
DB_CONNECTION=mysql
6php artisan makes: controller UserController5
php artisan make:export ExportUser --model=User_0
5. Buat Impor kelas impor untuk mengimpor data. Paket maatwebsite/excel menyediakan Anda untuk membuat file kelas impor. Menggunakan perintah berikut, kami membuat file kelas impor
php artisan make:import ImportUser --model=User
File akan dibuat di app/Imports/ImportUser. jalur php
PHP
composer require maatwebsite/excel_2
DB_HOST=127.0.0.1
0 DB_HOST=127.0.0.1
1
php artisan make:export ExportUser --model=User3
DB_HOST=127.0.0.1
3php artisan make:export ExportUser --model=User3
DB_HOST=127.0.0.1
5composer require maatwebsite/excel8
DB_HOST=127.0.0.1
7DB_HOST=127.0.0.1
8 DB_HOST=127.0.0.1
9DB_PORT=8258
_0
DB_PORT=8258
1DB_PORT=8258
2 DB_PORT=8258
3 DB_PORT=8258
4DB_PORT=8258
5 DB_PORT=8258
6DB_PORT=8258
7
DB_PORT=8258
1DB_PORT=8258
0
DB_DATABASE=laravel
0DB_DATABASE=laravel
1 DB_DATABASE=laravel
2 DB_DATABASE=laravel
3
DB_DATABASE=laravel
4DB_DATABASE=laravel
5
php artisan make:import ImportUser --model=User5
DB_PORT=8258
6DB_DATABASE=laravel
8DB_DATABASE=laravel
4
composer require maatwebsite/excel00
php artisan make:import ImportUser --model=User5
DB_PORT=8258
6________1______03DB_DATABASE=laravel
4
composer require maatwebsite/excel05
composer require maatwebsite/excel06
DB_PORT=8258
6composer require maatwebsite/excel08
DB_DATABASE=laravel
0
composer require maatwebsite/excel10
DB_PORT=8258
1
composer require maatwebsite/excel12
composer require maatwebsite/excel_12
6. Buat kelas Ekspor untuk mengekspor data. Paket maatwebsite/excel menyediakan Anda untuk membuat file kelas ekspor. Menggunakan perintah berikut, kami membuat file kelas ekspor
php artisan make:export ExportUser --model=User
File akan dibuat di app/Exports/ExportUser. jalur php
PHP
composer require maatwebsite/excel_2
composer require maatwebsite/excel_3
DB_HOST=127.0.0.1
0 composer require maatwebsite/excel17
composer require maatwebsite/excel_3
php artisan make:export ExportUser --model=User3
DB_HOST=127.0.0.1
3composer require maatwebsite/excel3
php artisan make:export ExportUser --model=User3
composer require maatwebsite/excel23
composer require maatwebsite/excel3
composer require maatwebsite/excel8
composer require maatwebsite/excel26
DB_HOST=127.0.0.1
8 composer require maatwebsite/excel28
composer require maatwebsite/excel29
DB_PORT=8258
2 DB_PORT=8258
3 composer require maatwebsite/excel32
composer require maatwebsite/excel_29
DB_PORT=8258
0php artisan makes: controller UserController1
DB_DATABASE=laravel
1 composer require maatwebsite/excel37
DB_DATABASE=laravel
5php artisan makes: controller UserController0
composer require maatwebsite/excel00
composer require maatwebsite/excel41
composer require maatwebsite/excel29
composer require maatwebsite/excel12
composer require maatwebsite/excel_3
composer require maatwebsite/excel12
php artisan make:export ExportUser --model=User_0
7. Buat Pengontrol. Untuk menampilkan data dari database, kita perlu membuat satu controller. Menggunakan perintah di bawah ini kami membuat pengontrol bernama UserController
php artisan makes: controller UserController
Perintah di atas akan membuat file pengontrol UserController. php di direktori path app/Http/controllers
Tulis kode di bawah ini ke dalam UserController. file php
PHP
composer require maatwebsite/excel_2
DB_HOST=127.0.0.1
0
composer require maatwebsite/excel49
php artisan make:export ExportUser --model=User3
composer require maatwebsite/excel51
php artisan make:export ExportUser --model=User3
composer require maatwebsite/excel53
php artisan make:export ExportUser --model=User3
composer require maatwebsite/excel55
php artisan make:export ExportUser --model=User3
composer require maatwebsite/excel57
php artisan make:export ExportUser --model=User3
DB_HOST=127.0.0.1
3
composer require maatwebsite/excel8
composer require maatwebsite/excel61
composer require maatwebsite/excel62
composer require maatwebsite/excel63
DB_PORT=8258
_0
composer require maatwebsite/excel3
DB_PORT=8258
2 DB_PORT=8258
3 composer require maatwebsite/excel68________1______69
composer require maatwebsite/excel70
composer require maatwebsite/excel29
DB_DATABASE=laravel
1 composer require maatwebsite/excel73
composer require maatwebsite/excel74
php artisan makes: controller UserController5
composer require maatwebsite/excel_3
composer require maatwebsite/excel12
composer require maatwebsite/excel3
DB_PORT=8258
2 DB_PORT=8258
3 composer require maatwebsite/excel81________1______69
composer require maatwebsite/excel70
composer require maatwebsite/excel29
composer require maatwebsite/excel85
DB_DATABASE=laravel
2 composer require maatwebsite/excel87
composer require maatwebsite/excel88
composer require maatwebsite/excel69
composer require maatwebsite/excel90
composer require maatwebsite/excel91
composer require maatwebsite/excel92
composer require maatwebsite/excel93
composer require maatwebsite/excel94
composer require maatwebsite/excel29
DB_DATABASE=laravel
1 composer require maatwebsite/excel97
composer require maatwebsite/excel_3
composer require maatwebsite/excel12
composer require maatwebsite/excel3
DB_PORT=8258
2 DB_PORT=8258
3 php artisan make:import ImportUser --model=User03
composer require maatwebsite/excel69
composer require maatwebsite/excel70
composer require maatwebsite/excel29
DB_DATABASE=laravel
1 php artisan make:import ImportUser --model=User08
DB_DATABASE=laravel
2 php artisan make:import ImportUser --model=User10
php artisan make:import ImportUser --model=User11
php artisan makes: controller UserController5
composer require maatwebsite/excel_3
composer require maatwebsite/excel12
php artisan make:import ImportUser --model=User15
composer require maatwebsite/excel12
php artisan make:export ExportUser --model=User_0
8. Buat file Blade/Tampilan. Untuk menangani ekspor dan impor di frontend aplikasi web, kita perlu membuat file view atau blade. Buat file blade di resources/views/importFile. Pedang. php
HTML
php artisan make:import ImportUser --model=User_18
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User20
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User23
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel3
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User27
php artisan make:import ImportUser --model=User28
php artisan make:import ImportUser --model=User27
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel3
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User33
php artisan make:import ImportUser --model=User34
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User36
composer require maatwebsite/excel_29
php artisan make:import ImportUser --model=User38
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User40
php artisan make:import ImportUser --model=User41
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User23
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User46
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel3
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User50
php artisan make:import ImportUser --model=User51
________323
composer require maatwebsite/excel_13_______53
composer require maatwebsite/excel3
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User50
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel3
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User60
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User63
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel29
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User60
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User70
php artisan make:import ImportUser --model=User21
php artisan makes: controller UserController1
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User60
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User77
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User79
php artisan make:import ImportUser --model=User80
________13______81
php artisan make:import ImportUser --model=User82
php artisan makes: controller UserController1
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User60
php artisan make:import ImportUser --model=User21
php artisan makes: controller UserController1
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User60
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User92
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User79
php artisan make:import ImportUser --model=User19
php artisan make:import ImportUser --model=User96
php artisan make:import ImportUser --model=User97
php artisan make:import ImportUser --model=User35
php artisan make:import ImportUser --model=User99
composer require maatwebsite/excel88
php artisan make:export ExportUser --model=User01
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User03
composer require maatwebsite/excel88
php artisan make:export ExportUser --model=User05
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User07
php artisan make:import ImportUser --model=User21
php artisan make:export ExportUser --model=User09
php artisan make:export ExportUser --model=User10
php artisan make:export ExportUser --model=User09
php artisan make:import ImportUser --model=User19
php artisan make:export ExportUser --model=User13
php artisan make:export ExportUser --model=User14
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User16
php artisan make:export ExportUser --model=User17
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User16
php artisan make:export ExportUser --model=User20
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User23
php artisan make:import ImportUser --model=User21
php artisan make:export ExportUser --model=User09
php artisan make:import ImportUser --model=User19
php artisan make:export ExportUser --model=User27
php artisan make:import ImportUser --model=User21
php artisan make:export ExportUser --model=User09
php artisan make:import ImportUser --model=User19
php artisan make:export ExportUser --model=User31
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User34
php artisan make:import ImportUser --model=User21
php artisan make:export ExportUser --model=User_36________22______37
php artisan make:export ExportUser --model=User38
php artisan make:import ImportUser --model=User42
php artisan make:export ExportUser --model=User31
php artisan make:import ImportUser --model=User21
php artisan make:export ExportUser --model=User09
php artisan make:import ImportUser --model=User19
php artisan make:export ExportUser --model=User44
composer require maatwebsite/excel8
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User47
php artisan make:export ExportUser --model=User38
php artisan make:import ImportUser --model=User38
php artisan make:import ImportUser --model=User35
php artisan make:export ExportUser --model=User51
php artisan make:import ImportUser --model=User21
php artisan make:export ExportUser --model=User53
php artisan make:export ExportUser --model=User54
composer require maatwebsite/excel88
php artisan make:import ImportUser --model=User42
php artisan make:export ExportUser --model=User44
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User79
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User96
php artisan make:import ImportUser --model=User21
php artisan makes: controller UserController1
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User60
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel29
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User60
php artisan make:import ImportUser --model=User21
composer require maatwebsite/excel3
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User60
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User46
php artisan make:import ImportUser --model=User21
php artisan make:import ImportUser --model=User42
php artisan make:import ImportUser --model=User20
php artisan make:import ImportUser --model=User21
9. Jalankan proyek laravel. Jalankan perintah di bawah ini pada command prompt dan periksa http. // localhost. 8000/file-import di browser