selection-screen

[Former Member]

hi experts,

I have a selection-screen which uploads an excel file, when i uploads an excel file i want to display no. of rows. That no. of rows should be displayed in the paramter field when i press a push button on the same selection screen.

1. Paramete type for excel upload.

2. Parameter type to get the no. of records in excel file (number of rows in that file).

3. one push button to display the no. of records in excel file.

i am using ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Hello,

U can easily do this.

AT SELECTION SCREEN.
if sy-ucomm = 'PUSH'.
" UPload the file to itab.
Describe table itab lines sy-lines.
p_nolines = sy-lines.
ENDIF:

Vasanth

[RichHeilman]

report zrich_0001 .


parameters: p_file type localfile.
parameters: p_rows type i.
selection-screen begin of block b1 with frame title text-001.
selection-screen pushbutton 1(20) go user-command go.
selection-screen end of block b1.



at selection-screen.
  case sy-ucomm.
    when 'GO'.

* Call your function here and then describe the internal table
* to get the number of rows,  then simply fill P_ROWS with that number
      p_rows = '40'.

  endcase.

Regards,

Rich HEilman