Upload Excel File with a length cell up to 300 char into internal table
I have a the following problem. I am trying to upload an excel file with long texts (about 700 char) and I am using FM ALSM_EXCEL_TO_INTERNAL_TABLE but the standard structure ALSMEX_TABLINE only allows char50. Do you have any idea to solve this without having to copy these FM/ structure to "Z"?
Thanks in advance.
Use this function module it will upload the long text
CLEAR : w_subrc.
DATA : wa_tab_raw_data TYPE truxs_t_text_data.
Function module to upload the excel file from presentation server
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
i_field_seperator = 'X'
i_line_header = 'X'
i_tab_raw_data = wa_tab_raw_data
i_filename = p_inp
i_tab_converted_data = t_input
conversion_failed = 1
OTHERS = 2.
IF sy-subrc <> 0.
w_subrc = 'X'.
Edited by: Krishna Gowrneni on Apr 21, 2009 8:07 PM
Edited by: Krishna Gowrneni on Apr 21, 2009 10:33 PM