Skip to Content
0
Former Member
Feb 28, 2011 at 05:34 PM

OPEN DATASET XLS FILE.

6094 Views

Hi Experts,

i already searched in this forum a solution, but i didn´t find yet.

So please i hope you can help-me. The issue is : I got a program wich have to read a XLS file from Aplication Server and put it into a internal table, When the file is downloaded on the program it´s comes a dirt string(vl_linha) like '##############'

my code

OPEN DATASET pm_arq FOR INPUT IN TEXT MODE ENCODING DEFAULT.

  IF sy-subrc <> 0.
    Error
  ENDIF.

  DO.
    READ DATASET pm_arq INTO vl_linha.

    IF sy-subrc <> 0.
      EXIT.
    ELSE.
      APPEND vl_linha TO tl_linha.
    ENDIF.
  ENDDO.

Do anyone knows the solution ?is possible read a XLS extension file ?

Thank a lot.