Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

issues of FM EXCEL_OLE_STANDARD_DAT

Former Member
0 Kudos
341

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!

1 ACCEPTED SOLUTION

Former Member
0 Kudos
57

Hello,

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

Regards,

Pedro

1 REPLY 1

Former Member
0 Kudos
58

Hello,

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

Regards,

Pedro