Excel file in app server

Former Member — Mon, 17 Dec 2007 12:35:04 GMT

Is there any FM to read data directly from an excel file in App server to Internal tables?

Re: Excel file in app server

former_member386202 — Mon, 17 Dec 2007 12:39:21 GMT

Hi,

There r no FM to upload the data from application server u have to use dataset

refer this code

*-- Open Dataset

OPEN DATASET lv_dsn FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc NE 0.

MESSAGE e503.

ELSE.

DO.

IF sy-subrc NE 0.

MESSAGE e504.

ENDIF.

*-- Read dataset and pass it to an internal table.

READ DATASET lv_dsn INTO lv_line.

CLEAR wa_eord.

wa_eord-matnr = lv_line+0(18).

wa_eord-werks = lv_line+18(4).

wa_eord-vdatu = lv_line+22(8).

wa_eord-bdatu = lv_line+30(8).

wa_eord-lifnr = lv_line+38(10).

wa_eord-ekorg = lv_line+48(4).

wa_eord-meins = lv_line+52(3).

wa_eord-autet = lv_line+55(1).

wa_eord-feskz = lv_line+56(1).

IF NOT wa_eord IS INITIAL.

APPEND wa_eord TO pr_eord.

ENDIF.

ENDDO.

*-- Close Dataset .

CLOSE DATASET lv_dsn.

ENDIF.

Regards,

Prashant