topic EXCEL in Application Development and Automation Discussions

EXCEL

Former Member — Sat, 15 Dec 2007 05:30:50 GMT

hi experts,

how to transfer the data which is in EXCEL sheet using BDC session method.

if it is with DAT file i can able to transfer.

explaine me with example.

thanks in advance.

Re: EXCEL

Former Member — Sat, 15 Dec 2007 05:53:10 GMT

Use FM,

<b>'ALSM_EXCEL_TO_INTERNAL_TABLE'.</b>

Check this link for sample program.

Regards,

Maha

Re: EXCEL

Former Member — Sat, 15 Dec 2007 06:08:19 GMT

thanks u mahalakshmi.

Re: EXCEL

Former Member — Sat, 15 Dec 2007 06:14:59 GMT

Hi Surendra,

TRY this FM to do: TEXT_CONVERT_XLS_TO_SAP.

Example:

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR = 'X'

I_LINE_HEADER = 'X'

i_tab_raw_data = itab

i_filename = 'C:\My Docs\Testing Files\demo.xls'

tables

i_tab_converted_data = it_student

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDIF.

LOOP AT it_student into it_student_wa.

Write: / it_student_wa-ID, it_student_wa-Name,

it_student_wa-ADDRESS,it_student_wa-STATE,

it_student_wa-CITY.

ENDLOOP.

<b>Kindly Reward points if you found this reply helpful</b>,

Cheers,

Chaitanya.

Re: EXCEL

Former Member — Sat, 15 Dec 2007 06:39:46 GMT

thanks chaitanya,

where r u from?

Re: EXCEL

Former Member — Sun, 16 Dec 2007 05:25:54 GMT

i am from orissa