FROM EXCEL FILE TO INTERNAL TABLE
i'm using the following code to conver the excel file into internal table.
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
I_FIELD_SEPERATOR = 'X'
I_TAB_RAW_DATA = IT_TAB_RAW_DATA
I_FILENAME = P_FILE
I_TAB_CONVERTED_DATA = IT_MM01
CONVERSION_FAILED = 1
OTHERS = 2
What is the exact format for the to send the Excel File.
My requirement is the Excel file contains the several fields , that should be stored as a records in the internal table
My problem is when i send the data in the excel file as one column, i'm getting all the data in the first column of the Internal Table.
If i send the data in the excel file as a record it is not filling the internal table.
what is the problem??/
if the Excel files contain multiple records is it able to convert the data into internal table records.