Skip to Content

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

Upload Excel File with a length cell up to 300 char into internal table

Hi all.

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.

Former Member
Former Member replied

Hi,

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'

EXPORTING

i_field_seperator = 'X'

i_line_header = 'X'

i_tab_raw_data = wa_tab_raw_data

i_filename = p_inp

TABLES

i_tab_converted_data = t_input

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

w_subrc = 'X'.

ENDIF.

Regards

Krishna

Edited by: Krishna Gowrneni on Apr 21, 2009 8:07 PM

Edited by: Krishna Gowrneni on Apr 21, 2009 10:33 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question