【16.2.5】调用resumePaint()后数据丢失

收藏

如下代码所示，附件中文件包含多个sheet页，验证每个sheet页内容，先挂起后恢复，将获取到的内容回显至一个合并sheet页中

在【简图】sheet页内容回显到合并页面上后，获取【E50_TNB09】sheet页内容，然后执行workbook.resumePaint()后，合并sheet页上的【简图】内容丢失

for (let index = uploadWorkbook.getSheetCount() - 1; index >= 0; index--) {
      const importSheet = uploadWorkbook.getSheet(index)
      console.log('uploadWorkbook', importSheet.name())
      const sheetName = importSheet.name()
      // eslint-disable-next-line @typescript-eslint/no-unused-vars
      const mapping = instance.value.getViewTableMapping()[0
      if (!['首页', 'Evaluation Version'].includes(sheetName)) {
      workbook.suspendPaint()

      if (instance.value.importExcelData) {
         instance.value.importExcelData(workbook, importSheet, sheetName)//获取内个sheet页内容回显至合并页
      }

      workbook.resumePaint()
      }
   }

image.png152662963.png