- 从excel 导入日期会自动转换成一个数字(number格式) 这个数字是减掉1900年1月1日的天数后得到的
例如 25569就是 1970-01-01
public import(target: DataTransfer): Observable<SearchResult> {
const subject = new ReplaySubject<SearchResult>();
const reader: FileReader = new FileReader();
const result: SearchResult = {
isSuccessful: true,
errMessage: '',
records: []
};
reader.onload = (e: any) => {
try {
/* read workbook */
const bstr: string = e.target.result;
const wb: XLSX.WorkBook = XLSX.read(bstr, { type: 'binary' });
/* grab first sheet */
const wsname: string = wb.SheetNames[0];
const ws: XLSX.WorkSheet = wb.Sheets[wsname];
/* save data */
this.trimExcelFormat(ws);