Hi,
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
Name Age
ABC 10
DEF 15
blank blank
XYZ 20
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?
Thank You
Vipin Rajan