topic Re: Problem while using TEXT_CONVERT_XLS_TO_SAP in Application Development and Automation Discussions

Problem while using TEXT_CONVERT_XLS_TO_SAP

far_sid210333 — Wed, 23 Nov 2022 04:40:14 GMT

While using this FM I'm getting an error T:

Message class: SOFFICEINTEGRATION

Message number: 899

Message text: Method "&2" of object "&1" was not executed

Does anybody have any suggestions on how to rectify this error?

Thanks

Farhan

Re: Problem while using TEXT_CONVERT_XLS_TO_SAP

FredericGirod — Wed, 23 Nov 2022 07:15:06 GMT

Yes, do not use this FM

It is not released by SAP, so you should not used it

Use ABAP2XLSx

Re: Problem while using TEXT_CONVERT_XLS_TO_SAP

abo — Wed, 23 Nov 2022 07:21:45 GMT

Try to provide some context, for example how it is called and with what values

Re: Problem while using TEXT_CONVERT_XLS_TO_SAP

far_sid210333 — Wed, 23 Nov 2022 10:28:09 GMT

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
* I_FIELD_SEPERATOR = 'X'
I_LINE_HEADER = 'X'
i_tab_raw_data = WA_STRUCT
i_filename = P_FILE
TABLES
i_tab_converted_data = IT_DETAILS[]
EXCEPTIONS
CONVERSION_FAILED = 1
OTHERS = 2
.

Just passing the file name and trying to get the details into an internal table. But the data

is not coming in the internal table sometimes. When I debugged the FM I found this error.



So please if you know anything regarding this or any alternative of it, then please share.

Re: Problem while using TEXT_CONVERT_XLS_TO_SAP

far_sid210333 — Wed, 23 Nov 2022 10:29:55 GMT

How can I install this. I tried it but I'm not able to do it.

Re: Problem while using TEXT_CONVERT_XLS_TO_SAP

Patrice — Thu, 24 Nov 2022 21:36:47 GMT

ABAP2XLSX is an open-source solution that must be installed in your SAP system. Search the Web for it and you will find the whole procedure and documentation on GitHub.

Hope this helps.

Patrice