Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FROM EXCEL FILE TO INTERNAL TABLE

HI GURU'S,

i'm using the following code to conver the excel file into internal table.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

  • I_FIELD_SEPERATOR = 'X'

  • I_LINE_HEADER =

I_TAB_RAW_DATA = IT_TAB_RAW_DATA

I_FILENAME = P_FILE

TABLES

I_TAB_CONVERTED_DATA = IT_MM01

EXCEPTIONS

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.

Regards,

Adi.

Tags:
Not what you were looking for? View more on this topic or Ask a question