Skip to Content
0
May 22, 2020 at 07:58 AM

MS_EXCEL_OLE_STANDARD_DAT comma

118 Views Last edit May 22, 2020 at 08:38 PM 2 rev

Dear all,

I'm using FM MS_EXCEL_OLE_STANDARD_DAT to download an excel with Material Characteristics. This is how I'm invoking it:

CALL FUNCTION 'MS_EXCEL_OLE_STANDARD_DAT'
EXPORTING * FILE_NAME = LV_FILE
TABLES
DATA_TAB = IT_CARACTERISTICAS " Product Characteristics
FIELDNAMES = IT_CABECERA " Excel File Header
EXCEPTIONS
FILE_NOT_EXIST = 1
FILENAME_EXPECTED = 2
COMMUNICATION_ERROR = 3
OLE_OBJECT_METHOD_ERROR = 4
OLE_OBJECT_PROPERTY_ERROR = 5
INVALID_PIVOT_FIELDS = 6
DOWNLOAD_PROBLEM = 7
OTHERS = 8

This function fulfills the requirements in a 99'7.

But in spite of formatting the fields accordingly before calling the FM, I've just realized two things I would need to modify on the output

1.- Material Number has no leading zeros. I would need it to be displayed on the file.
2.- Decimal figures are displayed with comma, I would need to be displayed as "dots".

Has anybody faced this issues?. Any suggestions?. Any clues?.

I would really appreciate your help!

Kind Regards!

Raúl