Get Data From Excel File Using Function ALSM_EXCEL_TO_INTERNAL_TABLE ABAP

2 November 2017
October 26, 2017

Here I will show code for get data from excel file .xls or .xlsx or .xlsm for upload data purpose. I using one parameters for accommodate the path from local file.

PARAMETERS: p2_path  TYPE string.

 

To display popup browse to local file as search help, please code below

 

Call the function module like code below

The result from this function like pic below :

If necessary you can collect data from function module to one itab.

The code below example for collect the itab from function into new one internal table

 

Hope this code snippet help you

thanks

Related Post