upload excel file to internal table
My requirement is to upload a excel file from presentation server into internal table.
i cannot use FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' it does not fits my requirement,
I have tried FM 'TEXT_CONVERT_XLS_TO_SAP' but it returns SY-TABIX 1 which means conversion
I have used FM GUI_UPLOAD but i get the scrap data in my table for keeping the filetype ASC in exporting parameters and if i give the filetype XLS for excel than i get nothing in my return table.
please suggest some helpfull solution.