---
# System prepended metadata

title: execl 匯入 api 測試

---

# execl 匯入 api 測試
## 人員匯入api

- 在 excel 新增資料時 工號與 mail 需手動填寫

## 誘卵桶匯入 api

| excel 資料狀態 | 匯入結果 | api 回復訊息 | 備註 |
| -------- | -------- | -------- |--------   |
| "地址" 區域輸入錯誤的區域 | 失敗 | Failed to import barrel_temas.xls, reason: column "none" does not exist LINE 6045: ...1975722277, '大門左側柱子旁(靠大馬路)', '', 2986, None, '', ... ^ HINT: Perhaps you meant to reference the column "barrel_placement.note". | 有顯示第幾列資料有誤，但沒顯示哪一個資料欄位有誤 |
| 新增一列誘卵桶資料 | 失敗 | Failed to import barrel_temas.xls, reason: column "none" does not exist LINE 6580: ...4085465, 22.963450458601134, '後方鐵柱下888', '', None, 382,... ^ HINT: Perhaps you meant to reference the column "barrel_placement.note" | 有顯示第幾列資料有誤，但列數有誤，並沒顯示哪一個資料欄位有誤 |