# Laravel Excel

> 用來處理 excel 的匯入

https://docs.laravel-excel.com/3.1/getting-started/

# 基礎

- [安裝](https://docs.laravel-excel.com/3.1/getting-started/installation.html)

# 架構概念
https://docs.laravel-excel.com/3.1/architecture/

## 生命週期
### Exports Lifecycle Overview
- Export Object => 都是從它開始
- Passing on the Export object => Export object 會 pass 給 Laravel Excel package, 有多種呼叫的方式
- Facade
- Dependency injection
- Contract
- Exportable trait
- Handling the Export object
- Writer type detection
- Starting the Writing process
- Multiple sheets => 判斷是否是多個 sheet
- Processing the sheets => 處理 sheet
- Passing on to PhpSpreadsheet
- Creating a Response
- Download the file
- Storing the file

### [Imports Lifecycle Overview](https://docs.laravel-excel.com/3.1/architecture/#imports-lifecycle-overview)

- Import Object
- Passing on the Import object
- Handling the Import object
- Starting the Reading process
- Multiple sheets
- Processing the sheets

# Exports 相關 features
https://docs.laravel-excel.com/3.1/exports/

# Imports 相關 features
https://docs.laravel-excel.com/3.1/imports/

- [Importing basics](https://docs.laravel-excel.com/3.1/imports/basics.html#importing-basics)
- 匯入或上傳處理
- another disk
- upload file
- full path
- 轉換
- array
- collection
- [Importing to collections](https://docs.laravel-excel.com/3.1/imports/collection.html#importing-to-collections)
- 轉成 collection
- [Importing to models](https://docs.laravel-excel.com/3.1/imports/model.html#importing-to-models)
- 轉成 eloquent model

- [Multiple Sheets](https://docs.laravel-excel.com/3.1/imports/multiple-sheets.html#multiple-sheets)
- 處理 multiple sheets
- [Heading row](https://docs.laravel-excel.com/3.1/imports/heading-row.html#heading-row)
- 處理每列資料
- 設定起始第幾列
- [Row Validation](https://docs.laravel-excel.com/3.1/imports/validation.html#row-validation)
- 驗證每一列
- [Progress Bar](https://docs.laravel-excel.com/3.1/imports/progress-bar.html)
- 顯示進度條

設定起始 row
https://stackoverflow.com/questions/56726778/how-to-skip-first-row-when-importing-file

###### tags: `2022` `laravel` `excel` `laracel-excel`

{%hackmd BJrTq20hE %}