Convert macro enable file content fron xstring to internal table

[former_member405231]

We are reading the content of macro enabled excel file(xslb) while attaching to the fiori application. We are getting file content in xstring format.

Now we need to get the XSTRING into internal table for further processing of the data.

To achieve this we are performing the below steps

1. With the help of FM: SCMS_XSTRING_TO_BINARY we are converting the content into binary format.

2. With the hep of FM: SCMS_BINARY_TO_TEXT we are converting the binary content to text format but we are getting junk character after conversion.

However in case of (.txt & .xls) files conversion works fine.

Please suggest how we can achieve this.