Function Module

[Former Member]

Hi,

Pls tell me what is the function of following FM.

MS_EXCEL_OLE_STANDARD_DAT.

Thanks.

[Former Member]

Hi,

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

Reward points if useful.

Regards,

Atish

[amit_khare]

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.

[Former Member]

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

[Former Member]

hi

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^