=>In SAPGUI release 6.40, one can directly attach the excel to test configuration.
=>In SAPGUI 6.20, read the excel using function module
'CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD' in ABAP-ENDABAP block. Find the count of lines. Using DO-ENDO loop using the count of lines as counter, assign the current set of data to transaction.