typescript - 我正在尝试更新现有的 Excel 工作表数据，但它给了我错误：TypeError: Cannot read property 'toString' of undefined

Question

我需要下载一个excel模板，填写数据并上传回来。我正在使用 exceljs。读取文件数据，更新然后尝试保存工作簿给出错误：“TypeError：无法读取未定义的属性'toString'”。

await wb.xlsx.readFile(filename).then(async()=>{          
            
            let Code:number, Active :number ;
            console.log("Workbook is: "+wb);
            let workSheet:excel.Worksheet = wb.getWorksheet("Sheet1"); //I can't create new worksheet i have to update existing worksheet's cell values.
            console.log("Worksheet is: "+workSheet);
            
            workSheet.getRow(7).eachCell(function(cell, colNumber){
                console.log('Cell ' + colNumber + ' = ' + cell.value);
                switch(cell.value)
                {
                    case "Code":{
                        Code = colNumber;
                        break;       

                    }
                    case"Active":{
                        Active = colNumber;
                        break;
                    }
                }            

            });
            await browser.sleep(6000);
            console.log(workSheet.getRow(8).getCell(Code).value + "Active : "+
            workSheet.getRow(8).getCell(Active).type.toString());
            var row =workSheet.getRow(8);
            row.getCell(8).value= 'Y';
            
           
           return wb.xlsx.writeFile(filename);
            
        });

标签： typescriptprotractorexceljs