issues of FM EXCEL_OLE_STANDARD_DAT

[Former Member]

Hi experts,

Now i come across two issures while using the FM EXCEL_OLE_STANDARD_DAT.

the exect codes is as following:

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

EXPORTING

file_name = 'C:\Carl'

TABLES

data_tab = lt_data

fieldnames = lt_label

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

.

the very issues which i facing are as following:

1 while I run the PROGRAM ,the executed Excel file is auto pened ,is it possible to generate the Carl.XLS file and with out

open the generated file? if it is possible ,hope you could gvie me your solution!

2 While I execute the PROGRAM two files are generated,one is Carl.xls,the other is Carl.dat.

is it possible to avoid to generate the second file which i don't wished! how could i realise it?

hope to receive your response!

best regards!

[Former Member]

Hello,

try FM XXL_SIMPLE_API instead. It will open excel with your data.

Regards,

Pedro