Excel Upload in SRM System
Dear Experts,
Am trying to upload excel file(xls) in SRM system using below code but am getting data in Chinese format don't know how to convert into normal format and i used other format like .CSV(Comma del..) but in this am getting data but getting with special characters like (, #) , please help me to upload excel file(xls format) file to internal table.
CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD
EXPORTING
FILENAME = L_FHEAD01
FILETYPE = 'ASC'
* HAS_FIELD_SEPARATOR = '|'
* HEADER_LENGTH = 0
* READ_BY_LINE = 'X'
DAT_MODE = 'X' "SPACE
* CODEPAGE = SPACE
* IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
* VIRUS_SCAN_PROFILE =
* IMPORTING
* FILELENGTH =
* HEADER =
CHANGING
DATA_TAB = LT_TRAN
* ISSCANPERFORMED = SPACE
EXCEPTIONS
FILE_OPEN_ERROR = 1
FILE_READ_ERROR = 2
NO_BATCH = 3
GUI_REFUSE_FILETRANSFER = 4
INVALID_TYPE = 5