compare - 将每个工作表的数据源或单元格值与另一个电子表格 ejs 进行比较

Question

我是新来的。我正在使用 EJ 电子表格表 js 显示电子表格。我想将“一个电子表格中的所有工作表”与另一个进行比较。谁能给我一个使用普通 JavaScript 的解决方案

标签： comparecellspreadsheetsyncfusion

Answer 1

您可以通过比较从工作表对象中检索到的带标记的“dataSource”属性来实现您的要求。这里数据使用 dataSource 属性绑定到电子表格，并在按钮单击事件中比较两个电子表格的数据源。

您可以在下面的工作代码示例中尝试，也可以参考示例 http://jsplayground.syncfusion.com/2pd3dmtq

 <button id ="btn" onclick="onClick()">Click To Compare</button>
<h2> Spreadsheet1</h2>
<div id="Spreadsheet1"></div> 
<h2>Spreadsheet2</h2>
<div id="Spreadsheet2"></div>

<script>
    datasource = [
            { OrderID: 10001, CustomerID: "VINET", Freight: 12.256, Load: 123456 },
            { OrderID: 10002, CustomerID: "TOMSP", Freight: 23.3, Load: 1234 },
            { OrderID: 10003, CustomerID: "HANAR", Freight: 12.256, Load: 123456 },
            { OrderID: 10004, CustomerID: "VICTE", Freight: 23.3, Load: 1234 },
            { OrderID: 10005, CustomerID: "SUPRD", Freight: 12.256, Load: 123456 },
            { OrderID: 10006, CustomerID: "CHOPS", Freight: 23.3, Load: 1234 },
    ];

  datasource1 = [
            { OrderID: 10001, CustomerID: "VINET", Freight: 12.256, Load: 123456 },
            { OrderID: 10002, CustomerID: "TOMSP", Freight: 23.3, Load: 1234 },
            { OrderID: 10003, CustomerID: "HANAR", Freight: 12.256, Load: 123456 },
            { OrderID: 10004, CustomerID: "VICTE", Freight: 23.3, Load: 1234 },
            { OrderID: 10005, CustomerID: "SUPRD", Freight: 12.256, Load: 123456 },
            { OrderID: 10006, CustomerID: "CHOPS", Freight: 23.3, Load: 1234 }]

    $(function () {
        $("#Spreadsheet1").ejSpreadsheet({
            showRibbon: false,
          allowFormulaBar: false,
            columnWidth: 100,
            sheets: [{
                dataSource: window.datasource // Bind data for sheets using dataSource property
            }
           ],
        });
       $("#Spreadsheet2").ejSpreadsheet({
            showRibbon: false,
            columnWidth: 100,
         allowFormulaBar: false,
            sheets: [{
                dataSource: window.datasource1 // Bind data for sheets using dataSource property
            }],
        });
    });

    function onClick(args) {
        var ssObj1 = $("#Spreadsheet1").data("ejSpreadsheet"), ssObj2 = $("#Spreadsheet2").data("ejSpreadsheet"),
            sheet1ActIdx = ssObj1.getActiveSheetIndex(),sheet2ActIdx = ssObj2.getActiveSheetIndex(),
            sheet1DataSrc = ssObj1.getSheet(sheet1ActIdx).dataSource, // To access the datasource by passing the sheetIndex 
            sheet2DataSrc = ssObj2.getSheet(sheet2ActIdx).dataSource; 
        alert("The Datasource for Spreadsheet1 and Spreadsheet2 are " + (JSON.stringify(sheet1DataSrc) == JSON.stringify(sheet2DataSrc) ? "same":  "different"));
    }
</script>

您能否检查样品并让我们知道它是否满足您的要求。