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

xn1cxnb4 于 2022-12-19 发布在其他

关注(0)|答案(1)|浏览(121)

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")',
            ]
        ],
    }]
});