Skip to Content

Convert macro enable file(Xlsb) content fron xstring to internal table

Mar 24, 2017 at 09:16 AM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers