时间戳

首页 > 解决方案 > js-xls - Angular 上的工作表到 json 只返回第一行

angular - js-xls - Angular 上的工作表到 json 只返回第一行

问题描述

我有一个包含这些数据的 xlsx 文件：

Totale venduto  |   Differenza  |   Totale incassato
3.354,95        |   16,73       |   3.371,68

该文件以 的形式发送到方法，readBlob如BLOB以下代码所示：

import { utils, write, read, readFile, WorkBook, WorkSheet, } from 'xlsx';

export class ExportXlsService
{
    public readBlob(data: any)
    {
        let reader = new FileReader()
        reader.onload = () =>
        {
            let u8 = new Uint8Array(reader.result);
            let wb: WorkBook = read(u8, { type: 'array' });        
            let wsname: string = wb.SheetNames[0];
            let ws: WorkSheet = wb.Sheets[wsname];        
            console.log(JSON.stringify(ws));
            // Read data                
            let xlsData = utils.sheet_to_json(ws, { header: 1 });    
            console.log(JSON.stringify(xlsData));
        }
        reader.readAsArrayBuffer(data);
    }
}

我不明白为什么当我调用utils.sheet_to_json它时只返回第一个数据行。

以下是控制台输出：

{"!ref":"A1:C1","A1":{"t":"s","v":"Totale venduto","r":"<t>Totale venduto</t>","h":"Totale venduto","w":"Totale venduto"},"B1":{"t":"s","v":"Differenza","r":"<t>Differenza</t>","h":"Differenza","w":"Differenza"},"C1":{"t":"s","v":"Totale incassato","r":"<t>Totale incassato</t>","h":"Totale incassato","w":"Totale incassato"},"A2":{"t":"n","v":3354.95,"w":"3,354.95"},"B2":{"t":"n","v":16.72999945282936,"w":"16.73"},"C2":{"t":"n","v":3371.679999452829,"w":"3,371.68"}}

[["Totale venduto","Differenza","Totale incassato"]]

标签： angulartypescriptjs-xlsx

解决方案

我发现了问题。在文档中，我看到工作表默认range为(ws['!ref']). 所以看着console.log(JSON.stringify(ws))我看到的内容，范围是"!ref":"A1:C1"。

将范围设置为"!ref":"A1:C2"：

let xlsData = utils.sheet_to_json(ws, { range: "A1:C2", header: 1 });

输出如下：

[["Totale venduto","Differenza","Totale incassato"],["3,354.95","16.73","3,371.68"]]

推荐阅读