Table Control Module pool program with Excel upload

[former_member800950]

The abv image is my table control......

when i upload the excel file with same input field with records ........ those records shld be seen in this table control .....

please help me how to do it?

this is my start of selection
START-OF-SELECTION.
  IF r1 = 'X'.
    CALL SCREEN 9000.
  ELSEIF r2 = 'X'.
    PERFORM file_selection.
    PERFORM upload.
    CALL SCREEN 9000.
  ELSEIF r3 = 'X'.
    PERFORM view_report.

  ENDIF.

[venkateswaran_k]

1. Is your Table control is linked to the internal table where you uploaded?

2. Share your code for screen 9000 - The PBO and PAI.

[former_member800950]

PROCESS BEFORE OUTPUT.
MODULE tablines.
MODULE status_9000.
MODULE get.

LOOP AT it_final INTO wa_final WITH CONTROL tabcontrol.

ENDLOOP.
*
PROCESS AFTER INPUT.

LOOP AT it_final.
MODULE modify.
ENDLOOP.
MODULE user_command_9000.

PROCESS ON VALUE-REQUEST.

FIELD wa_final-customer_place_order MODULE value.

[venkateswaran_k]

Is your MODULE get - that reads data from Excel?

[former_member800950]

no sir......that MODULE get is for Sno count.....

IF sy-ucomm = ' '.
DO 5 TIMES.

wa_final-sno = wa_final-sno + count.

APPEND wa_final TO it_final.
CLEAR : wa_final.
ENDDO.

ENDIF.

I have done dis for "sno" count in custom ztable updation wen entered records are saved which i created.....

[venkateswaran_k]

If it_final is the table that you linked to table control, then make sure it_final is populated before the statements.

MODULE tablines.

MODULE status_9000.

[former_member800950]

it_final has the field which are ther in abv table control......

what i need is...........wen i upload excel file in the output p_file path....... excel file which has the records shld be shown in table control after we upload it..... so as the user do it..... the records in excel file will be saved at once.......

[venkateswaran_k]

No, My question is

When you create the table control in the module pool, which internal table you connect to.

If you connect it correctly, once the data is uploaded in internal table, the data will be visible.

Try creating the table control using wizard so that you will not miss anything.

As per your rquirement, do as follows

1. create the table control using wizard

2. crete a button called upload

3. once the user press the upload, read from excel and populate the internal table

4. It iwll be visible once upload done successfully.