cancel
Showing results for 
Search instead for 
Did you mean: 

Excel was able to open the file by repairing or removing the unreadable content.

former_member311223
Participant
0 Kudos

Hi Experts,

We added the email functionality to the report and the Report is working fine, However when we open the attached excel sheet user get below message.


"Excel was able to open the file by repairing or removing the unreadable content.

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded."

Kindly suggest how can I get rid of this error?



Regards

Gopa




Accepted Solutions (0)

Answers (1)

Answers (1)

former_member311223
Participant

Hi All,

I got the solution for this issue.

Passed the Byte Count as below.

This Byte Count we get from

* Generate Excel File

  PERFORM generate_excel USING lv_title CHANGING lv_bytecount li_file_tab lk_xfile.

*   Convert to binary

    CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'

      EXPORTING

        buffer        = lv_filedata

      IMPORTING

        output_length = lv_bytecount

      TABLES

        binary_tab    = ch_ftab.

Regards

Gopa