topic Re: Function Module in Application Development and Automation Discussions

Function Module

Former Member — Thu, 05 Jul 2007 10:15:54 GMT

Hi,

Pls tell me what is the function of following FM.

MS_EXCEL_OLE_STANDARD_DAT.

Thanks.

Re: Function Module

Former Member — Thu, 05 Jul 2007 10:20:18 GMT

Hi,

this FM is used to upload the data from excel sheet.

Reward points if useful.

Regards,

Atish

Re: Function Module

amit_khare — Thu, 05 Jul 2007 10:20:38 GMT

MS_EXCEL_OLE_STANDARD_DAT is used to download data to Excel even in different worksheets.

Take a look at program SAPRDEMOEXCELINTEGRATION2. for usage.

Regards,

Amit

Reward all helpful replies.

Re: Function Module

Former Member — Thu, 05 Jul 2007 10:33:02 GMT

Hi,

Those methods are used for OLE

there is a note 721793 , that describes that MS_EXCEL_OLE_STANDARD_DAT is not released for the customers ...

Symptom

Customer-specific programs that use function module MS_EXCEL_OLE_STANDARD_DAT terminate with a runtime error, or other problems occur (formatting of numbers, dates, and so on), for example after you have changed the Windows/Office combination.

Other terms

Microsoft Excel, Microsoft XP, Excel download, termination, short dump, dump,runtime error, EXCEL_OLE_STANDARD_DAT, Excel 2002, Windows upgrade, CONVT_NO_NUMBER, CX_SY_CONVERION_NO_NUMBER, number format, date format, number formatting, date formatting, OBJECTS_NOT_CHARLIKE, TRANSLATE_DATA, SAPLSLPC, LSLPCU01, floating point numbers

Reason and Prerequisites

Data that is sent from R/3 to the frontend is independent of the Microsoft Windows/Office combination, it is the same data in all cases. The data is not modified in R/3 and it is not converted for frontend or Office, the data is simply passed on to Excel. The interpretation of the data by Excel is an Excel function only, R/3 is not involved at all. If Microsoft implements changes in this respect, SAP does not have any influence on that.

Due to the internal processing, the data table can only contain character-type types because. If this works with other data types, it is coincidence.

Solution

Function module MS_EXCEL_OLE_STANDARD_DAT is an internal function module which is not released.

The modules released by SAP can be found in function group TXXL. In this context, refer to Notes 109533 and 415983. In customer-specific programs, released function modules (for example, XXL_FULL_API or XXL_SIMPLE_API) should therefore be used.

<b>Reward points</b>

Regards

Re: Function Module

Former Member — Thu, 05 Jul 2007 10:38:41 GMT

good

use the function module given below to dowload u r data into excel with header.

CALL FUNCTION 'MS_EXCEL_OLE_STANDARD_DAT'

EXPORTING

file_name = p_outfle " path of file where u need to download

CREATE_PIVOT = 0
DATA_SHEET_NAME = ' '
PIVOT_SHEET_NAME = ' '
PASSWORD = ' '
PASSWORD_OPTION = 0

TABLES

PIVOT_FIELD_TAB =

data_tab = i_data " internal table with data

fieldnames = i_header " internal table with header

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.

thanks

mrutyun^