ALSM_EXCEL_TO_INTERNAL_TABLE not taking null values
I am uploading data from my excel sheet to an internal table. For this purpose i have used ALSM_EXCEL_TO_INTERNAL_TABLE.
The problem with this FM is that it does not consider the blank spaces.
for e.g if there is an Excel sheet with the following data
The internal table stores it as
row-001 col-001 value - ABC ; row-001 col-001 value - 10
row-002 col-001 value - DEF ; row-002 col-001 value - 15
row-004 col-001 value - XYZ ; row-004 col-001 value - 20
But i need the blank values as well i.e. values in row3.
Is there a work around for this?