javascript - 通过 javascript 获取 Excel 特定列值并将值赋给文本框

Question

我正在变量 excelRows 中获取整个 Excel 数据，此时我只想将“SRNO”列第一个值获取到文本框

function Upload() {
        //Reference the FileUpload element.
        var fileUpload = document.getElementById("ExcelFile");

        //Validate whether File is valid Excel file.
        var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.xls|.xlsx)$/;
        if (regex.test(fileUpload.value.toLowerCase())) {
            if (typeof (FileReader) != "undefined") {
                var reader = new FileReader();
                reader.onload = function (e) {
                    FillRow(e.target.result);
                };

                reader.readAsBinaryString(fileUpload.files[0]);
                reader.readAsArrayBuffer(fileUpload.files[0]);
            }
            else {
                alert("This browser does not support HTML5.");
            }
        } else {
            alert("Please upload a valid Excel file.");
        }
    };

    function FillRow(data) {
        var workbook = XLSX.read(data, {
            type: 'binary'
        });
        var sel_val = document.getElementById("ddlSheetName").value;
        var excelRows = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sel_val]);

        for (var j = 0; j <= excelRows.length; j++) {
            //how to fetch first value and last value of specific column
        }
    };

我是 Javascript 新手，因此我们将不胜感激。

Answer 1

您可以像这样更改 FillRow 函数:

function FillRow(data) {
    var workbook = XLSX.read(data, {
        type: 'binary'
    });

    var sel_val = document.getElementById("ddlSheetName").value;

    //var excelRows = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sel_val]);

    let excelRows = XLSX.utils.sheet_to_json(workbook.Sheets[sel_val])
    let firstRow = excelRows[0] // It contains your first row object.

    //how to fetch first value and last value of specific column
    let firstValue = Object.entries(firstRow)[0][1]
};

您可以在 excelRows 对象上运行循环。这只是获取第一个值的示例。