laravel 我想计算我用jspreadsheet调用的excel中的情绪的数量,但结果是#ERROR

xn1cxnb4  于 2022-12-19  发布在  其他
关注(0)|答案(1)|浏览(120)
var name = document.getElementById("name").value;
var url = window.location.origin + '/storage/excel-data/' + name

jspreadsheet(document.getElementById('spreadsheet'), {
    worksheets: [{
        csv: url,
        search: true,
        csvHeaders: true,
        tableOverflow:true,
        tableHeight:'450px',
        columns: [
            { width:300 },
            { width:80 },
            { width:100 },
        ],
        footers:[
            [
                'Total Positif',
                '=COUNTIF(H:H,"positive")',
            ],
            [
                'Total Negatif',
                '=COUNTIF(H:H,"negative")',
            ]
        ],
    }]
});

yyyllmsg

yyyllmsg1#

您需要使用扩展JSpreadsheet Formula Pro来运行此语法。

相关问题