topic Re: Function module:EXCEL_OLE_STANDARD_DAT in Application Development and Automation Discussions

Function module:EXCEL_OLE_STANDARD_DAT

Former Member — Wed, 10 Jan 2007 09:59:38 GMT

hi all,

In bdc download,while downloading the file using the function module :

EXCEL_OLE_STANDARD_DAT, zeros are appended in some of the columns of the first row in the excel sheet.

can anyone please help me out in this issue so that i do not get those zeros appended in the first row.

Thanks in advance,

Regards,

Thasneem

Re: Function module:EXCEL_OLE_STANDARD_DAT

Former Member — Wed, 10 Jan 2007 10:10:59 GMT

hi Fathima,

Check whether you are passing the parameters in this fashion only to the FM ...

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'
     EXPORTING
          FILE_NAME                 = 'C:USR03.XLS'
          DATA_SHEET_NAME           = 'USER LIST'
    TABLES
         DATA_TAB                  =  ITABUSR03
         FIELDNAMES                =  FLDITAB
 
    EXCEPTIONS
         FILE_NOT_EXIST            = 1
         FILENAME_EXPECTED         = 2
         COMMUNICATION_ERROR       = 3
         OLE_OBJECT_METHOD_ERROR   = 4
         OLE_OBJECT_PROPERTY_ERROR = 5
         INVALID_FILENAME          = 6
         INVALID_PIVOT_FIELDS      = 7
         DOWNLOAD_PROBLEM          = 8
         OTHERS                    = 9.
IF SY-SUBRC <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

Re: Function module:EXCEL_OLE_STANDARD_DAT

Former Member — Wed, 10 Jan 2007 10:19:24 GMT

Thank you Santosh.

i have tried the way you have told but still those zeros are appended.

Re: Function module:EXCEL_OLE_STANDARD_DAT

marcin_makowski — Wed, 10 Jan 2007 10:33:52 GMT

Fathima,

Just carefully check you excel file and remove all strange formatting, headers, invisible signs etc, just clean it up. It is very often helpful when you are doing data transfer from excel files.

Regards,

Marcin

Re: Function module:EXCEL_OLE_STANDARD_DAT

Former Member — Wed, 10 Jan 2007 10:43:44 GMT

hi Marcin,

I am downloading my data into an excel file.So, my output is an excel sheet . In my output i get those zeros in the first row in few columns.

Thanks in advance.

Regards,

Thasneem

Re: Function module:EXCEL_OLE_STANDARD_DAT

marcin_makowski — Wed, 10 Jan 2007 12:03:28 GMT

Fathima,

I have checked this FM in testing mode - it sets up always first row as a header if column names are specified, if not this row will be empty - actually it is working fine for me. Can you paste here content of both internal tables that you are passing to FM (data and column names) and also result from excel file?

Regards,

Marcin