编辑-读取Angular 5中的xlsx文件

npm install xlsx --save

import * as XLSX from 'xlsx';
import { ElementRef } from '@angular/core';

<input type="file" (change)="onFileChange($event)" style="display:none" #inputFile>
<button (click)="inputFile.click()">选择 Excel 文件</button>

@ViewChild('inputFile') inputFile: ElementRef;

onFileChange(evt: any) {
  const target: DataTransfer = <DataTransfer>(evt.target);

  if (target.files.length !== 1) {
    alert("只能上传一个文件");
    return;
  }

  const reader: FileReader = new FileReader();

  reader.onload = (e: any) => {
    const bstr: string = e.target.result;
    const wb: XLSX.WorkBook = XLSX.read(bstr, { type: 'binary' });

    const wsname: string = wb.SheetNames[0];
    const ws: XLSX.WorkSheet = wb.Sheets[wsname];

    this.data = XLSX.utils.sheet_to_json(ws);
    console.log(this.data);
  };

  reader.readAsBinaryString(target.files[0]);
}