topic Re: excel sheet in Application Development and Automation Discussions

excel sheet

Former Member — Fri, 27 Oct 2006 05:29:50 GMT

how to upload excel sheet into SAP using BDC

pls notify the function module .

regards

nageswara rao

hyderabad.

gopi_narendra — Fri, 27 Oct 2006 05:32:05 GMT

GUI_UPLOAD or ALSM_EXCEL_TO_INTERNAL_TABLE

function modules will upload the excel sheet data in to a internal table

Regards

- Gopi

Former Member — Fri, 27 Oct 2006 10:30:14 GMT

hi,

use FM <b>'ALSM_EXCEL_TO_INTERNAL_TABLE'</b>

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = p_infl

I_BEGIN_COL = 1

I_BEGIN_ROW = 2

I_END_COL = 8

I_END_ROW = 1000

TABLES

INTERN = T_DATA

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

ENDIF.

hope this helps,

do reward if it helps,

priya.

Former Member — Fri, 27 Oct 2006 10:35:13 GMT

Hi,

1) ALSM_EXCEL_TO_INTERNAL_TABLE

2) Gui_upload

3) ws_upload

4) FAA_FILE_UPLOAD_EXCEL

Try with this FM.

Thanks

Sunil