Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Spot instead comma in Excel from SAP

Hi all.

I get a Excel file from SAP. One of the fields is material, with format XXXXX.X in SAP, but in Excel it is shown with format XXXXX,X I need in Excel the material is shown with a spot, like SAP. What can I do?

The code is:

CREATE OBJECT Excel  'EXCEL.APLICATION'.

CALL METHOD OF Excel 'WORKBOOKS' = books.

CALL METHOD OF books 'ADD' = book.

LOOP AT tab.

PERFORM rellenar_celdas USING x1 tab-gltri.

PERFORM rellenar_celdas USING x2 tab-matnr.

....

ENDLOOP.

SET PROPERTY OF Excel 'VISIBLE' = 1.

---------------------------------------------------------------

FORM rellenar_celdas USING i j val.

CALL METHOD OF Excel 'CELLS' = cell

EXPORTING

#1 = i

#2 = j

SET PROPERTY OF cell 'VALUE' = val.

ENFORM.

Thanks a lot.

Marta.

replied

Hi

In the download data try and add extra " in front of the material .

Regards.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question