| | |
|---|
| | | const reader = new FileReader() |
|---|
| | | reader.onload = e => { |
|---|
| | | const data = e.target.result |
|---|
| | | const workbook = XLSX.read(data, { type: 'array' }) |
|---|
| | | const workbook = XLSX.read(data, { type: 'array', cellDates: true }) |
|---|
| | | let worksheet = [] |
|---|
| | | const header = [] |
|---|
| | | const results = [] |
|---|
| | | workbook.SheetNames.forEach((item, index) => { |
|---|
| | | worksheet = workbook.Sheets[item] |
|---|
| | | header.push(this.getHeaderRow(worksheet)) |
|---|
| | | results.push(XLSX.utils.sheet_to_json(worksheet)) |
|---|
| | | results.push(XLSX.utils.sheet_to_json(worksheet, { defval: null, raw: false })) |
|---|
| | | }) |
|---|
| | | this.excelData.sheetName = workbook.SheetNames |
|---|
| | | // console.log(header) |
|---|
