topic Re: How can i using this function with Gui Download ? in Application Development and Automation Discussions

How can i using this function with Gui Download ?

Former Member — Sun, 26 Jan 2014 18:27:33 GMT

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 — Mon, 27 Jan 2014 04:14:23 GMT

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 — Mon, 27 Jan 2014 05:10:34 GMT

Hi Burak,

Check out the link.

Regards,

Ravikiran.k