How can i using this function with Gui Download ?

[Former Member]

data yol type string.

concatenate 'D:\Proje Çalışanları\' gv_pjtx '.xls' into yol.

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

   EXPORTING

     file_name                       = yol

*   CREATE_PIVOT                    = 0

*   DATA_SHEET_NAME                 = ' '

*   PIVOT_SHEET_NAME                = ' '

*   PASSWORD                        = ' '

*   PASSWORD_OPTION                 = 0

  TABLES

*   PIVOT_FIELD_TAB                 =

    DATA_TAB                        = itab_detail_collected

*   FIELDNAMES                      =

  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

           .

[Former Member]

data yol type string.

concatenate 'D:\Proje Çalışanları\' gv_pjtx '.xls' into yol.

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

   EXPORTING

     file_name                       = yol

*   CREATE_PIVOT                    = 0

*   DATA_SHEET_NAME                 = ' '

*   PIVOT_SHEET_NAME                = ' '

*   PASSWORD                        = ' '

*   PASSWORD_OPTION                 = 0

  TABLES

*   PIVOT_FIELD_TAB                 =

    DATA_TAB                        = itab_detail_collected

*   FIELDNAMES                      =

  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

           .

[Former Member]

Hi,

- The FM will work only the online and it can be work to download the data into presentation server only

- This FM will not work in back ground

- you can use to create the PIVOT table also.

Mandatory parameters are

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT'

     EXPORTING

          FILE_NAME                 = ' file path of presentation server '

    TABLES

*         PIVOT_FIELD_TAB           =

         DATA_TAB                  = T_EXCEL1  " data

         FIELDNAMES                = FLDITAB  " which fields are required

[Former Member]

Hi Burak,

Check out the link.

GUI_DOWNLOAD - ERP Upgrade - SCN Wiki

Regards,

Ravikiran.k