Laravel excel lấy tên sheet
|
Đối với các ứng dụng web, nhập dữ liệu trang tính Excel vào cơ sở dữ liệu của chúng tôi và xuất dữ liệu từ cơ sở dữ liệu sang trang tính Excel, là một tính năng quan trọng. Nhờ tính năng này mà chúng ta có thể dễ dàng thực hiện nhập/xuất dữ liệu hàng loạt bằng ứng dụng web. Khó ở các Framework khác nhưng dễ nhất ở laravel 8. Nó cung cấp gói Maatwebsite/excel để dễ dàng nhập/xuất dữ liệu. Trong bài viết này, chúng ta tìm hiểu về cách xuất và nhập dữ liệu Show Đặc trưng
Các bước làm laravel Nhập xuất dữ liệu excel. Chúng tôi muốn làm theo một vài bước để nhập và xuất dữ liệu dễ dàng. Có 9 bước đơn giản để làm theo
1. Cài đặt dự án laravel mới. Ở bước đầu tiên, hãy tạo một dự án laravel mới có tên là laravel-excel. Sử dụng lệnh dưới đây để tạo một dự án laravel mới composer create-project laravel/laravel excel 2. Cấu hình chi tiết Cơ sở dữ liệu và tạo mô hình. Trong bước thứ hai, thiết lập cấu hình cơ sở dữ liệu trong. tệp env trong laravel 8 PHPcomposer require maatwebsite/excel20 composer require maatwebsite/excel21 composer require maatwebsite/excel22 composer require maatwebsite/excel23 composer require maatwebsite/excel0 composer require maatwebsite/excel1 làm mẫu. Sau đó tạo một model mới tên là User model để kết nối với bảng user trong cơ sở dữ liệu. Trong người dùng, bảng chứa nhiều trường khác nhau như ID, tên, điện thoại và email 3. Cài đặt gói maatwebsite/excel. Bây giờ, sử dụng trình soạn thảo, chúng tôi cài đặt tên gói maatwebsite/excel để xuất và nhập dữ liệu bằng cách sử dụng trình soạn thảo composer require maatwebsite/excel Sau khi cài đặt gói, chúng tôi muốn đăng ký dịch vụ của plugin trong nhà cung cấp và bí danh Chúng tôi muốn viết đoạn mã sau vào config/app. tập tin php PHPcomposer require maatwebsite/excel2 composer require maatwebsite/excel3____14 composer require maatwebsite/excel5 composer require maatwebsite/excel6 composer require maatwebsite/excel7____18 composer require maatwebsite/excel9 composer require maatwebsite/excel3____131 composer require maatwebsite/excel5 composer require maatwebsite/excel6 composer require maatwebsite/excel34 composer require maatwebsite/excel35 composer require maatwebsite/excel6 composer require maatwebsite/excel37 composer require maatwebsite/excel8 composer require maatwebsite/excel9 composer require maatwebsite/excel20 Để xuất bản cấu hình trên, hãy thực thi nhà cung cấp. xuất bản lệnh
Lệnh này là để tạo một tệp cấu hình mới config/excel. php 4. Tạo tuyến đường. Sau đó, chúng tôi tạo các tuyến để xử lý các yêu cầu từ tệp nhập và xuất PHPcomposer require maatwebsite/excel2 composer require maatwebsite/excel3____223 composer require maatwebsite/excel24 composer require maatwebsite/excel3____226______227 composer require maatwebsite/excel28 composer require maatwebsite/excel8 composer require maatwebsite/excel20 composer require maatwebsite/excel21 composer require maatwebsite/excel22 composer require maatwebsite/excel23 composer require maatwebsite/excel24 composer require maatwebsite/excel25 composer require maatwebsite/excel3______327 composer require maatwebsite/excel28 composer require maatwebsite/excel28 composer require maatwebsite/excel8 composer require maatwebsite/excel20 _______321____453____323____453 composer require maatwebsite/excel25 composer require maatwebsite/excel3____226____459____228 composer require maatwebsite/excel8 composer require maatwebsite/excel20 composer require maatwebsite/excel21 composer require maatwebsite/excel204 composer require maatwebsite/excel23 composer require maatwebsite/excel206 composer require maatwebsite/excel25 composer require maatwebsite/excel20 5. Tạo Nhập nhập lớp nhập cho dữ liệu nhập. Gói maatwebsite/excel cung cấp cho bạn để xây dựng tệp lớp nhập. Sử dụng lệnh sau, chúng tôi tạo một tệp lớp nhập composer require maatwebsite/excel3 Tệp sẽ tạo tại app/Imports/ImportUser. đường dẫn php PHPcomposer require maatwebsite/excel2 composer require maatwebsite/excel210 composer require maatwebsite/excel211 composer require maatwebsite/excel23 composer require maatwebsite/excel213 composer require maatwebsite/excel23 composer require maatwebsite/excel215 composer require maatwebsite/excel8 composer require maatwebsite/excel217 composer require maatwebsite/excel218 composer require maatwebsite/excel219 composer require maatwebsite/excel220 composer require maatwebsite/excel221 composer require maatwebsite/excel222 composer require maatwebsite/excel223 composer require maatwebsite/excel224 composer require maatwebsite/excel225 composer require maatwebsite/excel226 composer require maatwebsite/excel227 composer require maatwebsite/excel221____3220 composer require maatwebsite/excel230 composer require maatwebsite/excel231 composer require maatwebsite/excel232 composer require maatwebsite/excel233 composer require maatwebsite/excel234 composer require maatwebsite/excel235 composer require maatwebsite/excel35 composer require maatwebsite/excel226 composer require maatwebsite/excel238 composer require maatwebsite/excel234 composer require maatwebsite/excel00 composer require maatwebsite/excel35 composer require maatwebsite/excel226 composer require maatwebsite/excel03 composer require maatwebsite/excel234 composer require maatwebsite/excel05 composer require maatwebsite/excel06 composer require maatwebsite/excel226 composer require maatwebsite/excel08 composer require maatwebsite/excel230 composer require maatwebsite/excel10 composer require maatwebsite/excel221 composer require maatwebsite/excel12 composer require maatwebsite/excel12 6. Tạo một lớp Xuất để xuất dữ liệu. Gói maatwebsite/excel cung cấp cho bạn để xây dựng tệp lớp xuất. Sử dụng lệnh sau, chúng tôi tạo một tệp lớp xuất composer require maatwebsite/excel2 File sẽ tạo tại app/Exports/ExportUser. đường dẫn php PHPcomposer require maatwebsite/excel2 composer require maatwebsite/excel3____3210 composer require maatwebsite/excel17 composer require maatwebsite/excel3____223 composer require maatwebsite/excel213 composer require maatwebsite/excel3____223 composer require maatwebsite/excel23
composer require maatwebsite/excel3 composer require maatwebsite/excel8 composer require maatwebsite/excel26 composer require maatwebsite/excel218 composer require maatwebsite/excel28 composer require maatwebsite/excel29 composer require maatwebsite/excel222 composer require maatwebsite/excel223 composer require maatwebsite/excel32 composer require maatwebsite/excel29____3220 composer require maatwebsite/excel21 composer require maatwebsite/excel231 composer require maatwebsite/excel37____3235 composer require maatwebsite/excel20 composer require maatwebsite/excel00 composer require maatwebsite/excel41 composer require maatwebsite/excel29 composer require maatwebsite/excel12 composer require maatwebsite/excel3____112 composer require maatwebsite/excel20 7. Tạo bộ điều khiển. Để hiển thị dữ liệu từ cơ sở dữ liệu, chúng ta cần tạo một bộ điều khiển. Sử dụng lệnh dưới đây, chúng tôi tạo một bộ điều khiển có tên UserController composer require maatwebsite/excel2 Lệnh trên sẽ tạo một tệp điều khiển UserController. php tại đường dẫn thư mục app/Http/controllers Viết mã dưới đây vào UserController. tập tin php PHPcomposer require maatwebsite/excel2
composer require maatwebsite/excel210 composer require maatwebsite/excel49 composer require maatwebsite/excel23 composer require maatwebsite/excel51 composer require maatwebsite/excel23 composer require maatwebsite/excel53 composer require maatwebsite/excel23 composer require maatwebsite/excel55 composer require maatwebsite/excel23 composer require maatwebsite/excel57 composer require maatwebsite/excel23 composer require maatwebsite/excel213
composer require maatwebsite/excel8 composer require maatwebsite/excel61 composer require maatwebsite/excel62 composer require maatwebsite/excel63 composer require maatwebsite/excel220 composer require maatwebsite/excel3____3222 composer require maatwebsite/excel223 composer require maatwebsite/excel68 composer require maatwebsite/excel69 composer require maatwebsite/excel70 composer require maatwebsite/excel29 composer require maatwebsite/excel231 composer require maatwebsite/excel73 composer require maatwebsite/excel74 composer require maatwebsite/excel25 composer require maatwebsite/excel3____112
composer require maatwebsite/excel3____3222 composer require maatwebsite/excel223 composer require maatwebsite/excel81 composer require maatwebsite/excel69 composer require maatwebsite/excel70 composer require maatwebsite/excel29 composer require maatwebsite/excel85____3232 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 composer require maatwebsite/excel231 composer require maatwebsite/excel97 composer require maatwebsite/excel3____112
composer require maatwebsite/excel3____3222 composer require maatwebsite/excel223 composer require maatwebsite/excel303 composer require maatwebsite/excel69 composer require maatwebsite/excel70 composer require maatwebsite/excel29 composer require maatwebsite/excel231 composer require maatwebsite/excel308 composer require maatwebsite/excel232 composer require maatwebsite/excel310 composer require maatwebsite/excel311 composer require maatwebsite/excel25 composer require maatwebsite/excel3____112 composer require maatwebsite/excel315 composer require maatwebsite/excel12 composer require maatwebsite/excel20 8. Tạo Blade/Xem tập tin. Để xử lý xuất và nhập ở giao diện người dùng của ứng dụng web, chúng ta cần tạo tệp dạng xem hoặc tệp phiến. Tạo một tệp phiến tại resource/views/importFile. lưỡi. php HTMLcomposer require maatwebsite/excel318 composer require maatwebsite/excel319 composer require maatwebsite/excel320____1321
composer require maatwebsite/excel319 composer require maatwebsite/excel323____1321 composer require maatwebsite/excel3____1319 composer require maatwebsite/excel327 composer require maatwebsite/excel328 composer require maatwebsite/excel327 composer require maatwebsite/excel321 composer require maatwebsite/excel3______1319 composer require maatwebsite/excel333 composer require maatwebsite/excel334 composer require maatwebsite/excel335 composer require maatwebsite/excel336 composer require maatwebsite/excel29 composer require maatwebsite/excel338 composer require maatwebsite/excel335 composer require maatwebsite/excel340 composer require maatwebsite/excel341 composer require maatwebsite/excel342 composer require maatwebsite/excel323 composer require maatwebsite/excel321
composer require maatwebsite/excel319 composer require maatwebsite/excel346 composer require maatwebsite/excel321 composer require maatwebsite/excel3____1319 composer require maatwebsite/excel350 composer require maatwebsite/excel351 composer require maatwebsite/excel234 composer require maatwebsite/excel353 composer require maatwebsite/excel3____1342 composer require maatwebsite/excel350 composer require maatwebsite/excel321 composer require maatwebsite/excel3____1319 composer require maatwebsite/excel360 composer require maatwebsite/excel8 composer require maatwebsite/excel335 composer require maatwebsite/excel363 composer require maatwebsite/excel321 composer require maatwebsite/excel29 composer require maatwebsite/excel319 composer require maatwebsite/excel360 composer require maatwebsite/excel8 composer require maatwebsite/excel335 composer require maatwebsite/excel370 composer require maatwebsite/excel321 composer require maatwebsite/excel21 composer require maatwebsite/excel319 composer require maatwebsite/excel360 composer require maatwebsite/excel8 composer require maatwebsite/excel335 ________ 1377 composer require maatwebsite/excel321 composer require maatwebsite/excel379 composer require maatwebsite/excel380 _______1381____1382 composer require maatwebsite/excel21 composer require maatwebsite/excel342 composer require maatwebsite/excel360 composer require maatwebsite/excel321 composer require maatwebsite/excel21 composer require maatwebsite/excel319 composer require maatwebsite/excel360 composer require maatwebsite/excel8 composer require maatwebsite/excel335 composer require maatwebsite/excel392 composer require maatwebsite/excel321 composer require maatwebsite/excel379 composer require maatwebsite/excel319 composer require maatwebsite/excel396 composer require maatwebsite/excel397 composer require maatwebsite/excel335 composer require maatwebsite/excel399 composer require maatwebsite/excel88 composer require maatwebsite/excel201 composer require maatwebsite/excel335 composer require maatwebsite/excel203 composer require maatwebsite/excel88 composer require maatwebsite/excel205____1335 composer require maatwebsite/excel207 composer require maatwebsite/excel321 composer require maatwebsite/excel209 composer require maatwebsite/excel210 composer require maatwebsite/excel209 composer require maatwebsite/excel319 composer require maatwebsite/excel213 composer require maatwebsite/excel214 composer require maatwebsite/excel335 composer require maatwebsite/excel216 composer require maatwebsite/excel217 composer require maatwebsite/excel335 composer require maatwebsite/excel216 composer require maatwebsite/excel220 composer require maatwebsite/excel8____1335 composer require maatwebsite/excel223 composer require maatwebsite/excel321 composer require maatwebsite/excel209 composer require maatwebsite/excel319____2227 composer require maatwebsite/excel321 composer require maatwebsite/excel209 composer require maatwebsite/excel319 composer require maatwebsite/excel231 composer require maatwebsite/excel8 composer require maatwebsite/excel335 composer require maatwebsite/excel234 composer require maatwebsite/excel321 composer require maatwebsite/excel236 composer require maatwebsite/excel237 composer require maatwebsite/excel238 composer require maatwebsite/excel342 composer require maatwebsite/excel231 composer require maatwebsite/excel321 composer require maatwebsite/excel209 composer require maatwebsite/excel319____2244 composer require maatwebsite/excel8 composer require maatwebsite/excel335 composer require maatwebsite/excel247 composer require maatwebsite/excel238 composer require maatwebsite/excel338 composer require maatwebsite/excel335 composer require maatwebsite/excel251 composer require maatwebsite/excel321 composer require maatwebsite/excel253 composer require maatwebsite/excel254 composer require maatwebsite/excel88 composer require maatwebsite/excel342 composer require maatwebsite/excel244 composer require maatwebsite/excel321 composer require maatwebsite/excel379 composer require maatwebsite/excel342 composer require maatwebsite/excel396 composer require maatwebsite/excel321 composer require maatwebsite/excel21 composer require maatwebsite/excel342 composer require maatwebsite/excel360 composer require maatwebsite/excel321 composer require maatwebsite/excel29 composer require maatwebsite/excel342 composer require maatwebsite/excel360 composer require maatwebsite/excel321 composer require maatwebsite/excel3____1342 composer require maatwebsite/excel360 composer require maatwebsite/excel321
composer require maatwebsite/excel342 composer require maatwebsite/excel346 composer require maatwebsite/excel321
composer require maatwebsite/excel342 composer require maatwebsite/excel320 composer require maatwebsite/excel321 9. Chạy dự án laravel. Chạy lệnh dưới đây trên dấu nhắc lệnh và kiểm tra http. //máy chủ cục bộ. 8000/nhập tệp trong trình duyệt |
