当前位置：网站首页>SAP Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃。

SAP Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃。

2022-04-23 06:25:00 【rogerix4】

1. SAP导出Excel时报错

发现“test.xlsx”中的部分内容有问题。是否让我们尽量尝试恢复? 如果您信任此工作簿的源，请单击“是”
Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃。

2. 解决方法

获取二进制导出数据表时获取数据输出长度：l_length

方法一：

CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'
  EXPORTING
    buffer        = r_xstring
  IMPORTING
    output_length = l_length
  TABLES
    binary_tab    = binary_tab.

方法二：

CALL METHOD cl_bcs_convert=>xstring_to_solix
  EXPORTING
    iv_xstring = r_xstring
  RECEIVING
    et_solix   = binary_tab.

l_length = xstrlen( r_xstring ).

然后再调用cl_gui_frontend_services=>gui_download时，传入参数：bin_filesize = l_length

CALL METHOD cl_gui_frontend_services=>gui_download
  EXPORTING
    bin_filesize            = l_length
    filename                = `C:\Users\xxxx\Desktop\test.xlsx`
    filetype                = 'BIN'
  CHANGING
    data_tab                = binary_tab
  EXCEPTIONS
    file_write_error        = 1
    no_batch                = 2
    gui_refuse_filetransfer = 3
    invalid_type            = 4
    no_authority            = 5
    unknown_error           = 6
    header_not_allowed      = 7
    separator_not_allowed   = 8
    filesize_not_allowed    = 9
    header_too_long         = 10
    dp_error_create         = 11
    dp_error_send           = 12
    dp_error_write          = 13
    unknown_dp_error        = 14
    access_denied           = 15
    dp_out_of_memory        = 16
    disk_full               = 17
    dp_timeout              = 18
    file_not_found          = 19
    dataprovider_exception  = 20
    control_flush_error     = 21
    not_supported_by_gui    = 22
    error_no_gui            = 23
    OTHERS                  = 24.