topic Re: OPEN DATASET code for XLS file or csv file?? in Application Development and Automation Discussions

OPEN DATASET code for XLS file or csv file??

Former Member — Mon, 18 May 2009 10:02:54 GMT

Please let me know the code to read a xls or csv file from the SAP application unix server.I had written the code,but in case of xls file the output is junk values.

OUTPUT:###########3 OK &&&&&&&&&&&&&

is coming like this.

code:

DATA:BEGIN OF itab OCCURS 0,

matl_type(4) TYPE c,

matl_group(9) TYPE c,

matl_desc(40) TYPE c,

char_prof(18) TYPE c,

END OF itab.

DATA:wa LIKE itab.

DATA file TYPE string VALUE `/sap/inbound/master.xls`.

BREAK-POINT.

OPEN DATASET file FOR INPUT IN binary MODE.

IF sy-subrc = 0.

WRITE:'ok'.

ENDIF.

DO.

READ DATASET file INTO wa.

IF sy-subrc = 0.

itab = wa.

WRITE: / wa-matl_type,

wa-matl_group,

wa-matl_desc,

wa-char_prof.

APPEND itab.

ELSE.

EXIT.

ENDIF.

ENDDO.

CLOSE DATASET file.

please help me to correct this error.

in case of cvs file,when i comes to read dataset,my subrc = 4.

regds

vipin

Re: OPEN DATASET code for XLS file or csv file??

former_member242255 — Mon, 18 May 2009 10:21:52 GMT

after reading the dataset,you have to SPLIT the data that is got from the file so that the fields

are placed correctly into the corresponding fields..

Re: OPEN DATASET code for XLS file or csv file??

Former Member — Mon, 18 May 2009 10:28:04 GMT

Hi Vipin ,

I have made some changes tour code , now please check this code - -

DATA:BEGIN OF itab OCCURS 0,
matl_type(4) TYPE c,
matl_group(9) TYPE c,
matl_desc(40) TYPE c,
char_prof(18) TYPE c,
END OF itab.

DATA:wa LIKE itab.

DATA file TYPE string VALUE `/sap/inbound/master.xls`.



OPEN DATASET file FOR INPUT IN TEXT MODE ENCODING DEFAULT.
BREAK-POINT.
IF sy-subrc = 0.
*  WRITE:'ok'.


DO.
  READ DATASET file INTO wa.
  IF sy-subrc = 0.
    itab = wa.
    WRITE: / wa-matl_type,
    wa-matl_group,
    wa-matl_desc,
    wa-char_prof.
    APPEND itab.
  ELSE.
    EXIT.
  ENDIF.
ENDDO.
ENDIF.
CLOSE DATASET file.

Regards

Pinaki