topic Re: selection-screen in Application Development and Automation Discussions

selection-screen

Former Member — Tue, 26 Jun 2007 13:12:41 GMT

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

Re: selection-screen

Former Member — Tue, 26 Jun 2007 13:21:45 GMT

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

Re: selection-screen

RichHeilman — Tue, 26 Jun 2007 13:24:44 GMT



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