SAP excel has completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

1. SAP export Excel Times wrong

• Find out “test.xlsx” There is a problem with some of the contents in . Let's try to recover ? If you trust the source of this workbook , Please click on the “ yes ”
  

• Excel File level verification and repair completed . Some parts of this workbook may have been repaired or discarded .
  

2. resolvent

• Get the data output length when getting the binary export data table ：l_length

  • Method 1 ：

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

  • Method 2 ：

    CALL METHOD cl_bcs_convert=>xstring_to_solix
      EXPORTING
        iv_xstring = r_xstring
      RECEIVING
        et_solix   = binary_tab.
    
    l_length = xstrlen( r_xstring ).
    

• Then call cl_gui_frontend_services=>gui_download when , Pass in the parameter ：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.
  

• Corrected exported Excel It can be opened directly