Method parseExcelData

packages/amis/src/renderers/Form/InputExcel.tsx:526–566

* 解析 Excel 数据 * 支持解析所有 sheet 或单个 sheet * 支持解析图片和富文本

(excelData: ArrayBuffer | string, fileState: ExcelFile)

   * 支持解析图片和富文本
   */
  async parseExcelData(excelData: ArrayBuffer | string, fileState: ExcelFile) {
    const {allSheets, parseImage, plainText, translate: __} = this.props;
    try {
      const ExcelJS = (await import('exceljs')).default;
      this.ExcelJS = ExcelJS;
      const workbook = new ExcelJS.Workbook();

      const data =
        typeof excelData === 'string'
          ? new Uint8Array(excelData.split('').map(c => c.charCodeAt(0))).buffer
          : excelData;

      await workbook.xlsx.load(data);

      let sheetsResult: any;
      if (allSheets) {
        sheetsResult = this.parseAllSheets(workbook, parseImage, plainText);
      } else {
        const worksheet = workbook.worksheets.find(
          (sheet: any) => sheet.state !== 'hidden'
        );
        sheetsResult = parseImage
          ? {
              data: this.readWorksheet(worksheet, plainText),
              images: this.readImages(worksheet, workbook)
            }
          : this.readWorksheet(worksheet, plainText);
      }

      this.updateFileState(fileState.id, {
        state: 'parsed',
        data: sheetsResult
      });
    } catch (error) {
      console.error('Excel parsing error:', error);
      this.updateFileState(fileState.id, {
        state: 'error',
        error: error.message || __('Excel.parseError')
      });
    }
  }

  /**
   * 解析所有可见的 sheet