topic Re: Excel Data upload into the internal table in Application Development and Automation Discussions

Excel Data upload into the internal table

Former Member — Thu, 10 Jan 2008 16:36:44 GMT

Hi ,

I have a scenerio, in which i have to upload the data from the excel sheet into internal table for further processing. As the data volume is about 40000+ records FM ALSM_EXCEL_TO_INTERNAL_TABLE and KCD_EXCEL_OLE_TO_INT_CONVERT is not of much use . Is there any other way of processing the file ?.

regards

Saravanan

Re: Excel Data upload into the internal table

mnicolai_77 — Thu, 10 Jan 2008 17:00:26 GMT

hi,

try to convert the file in DAT format and use GUI_UPLOAD for uploading the data.

Using OLE integrations method are not the better way for loadings so bigger file.

bye

Marco

Re: Excel Data upload into the internal table

Former Member — Thu, 10 Jan 2008 17:28:41 GMT

Hai,

Follow this example:

DATA: BEGIN OF i_file_data OCCURS 0,

col1 TYPE text60,

col2 TYPE text60,

col3 TYPE text60,

col4 TYPE text60,

col5 TYPE text60,

col6 TYPE text60,

END OF i_file_data.

parameter: p_local TYPE rlgrap-filename MODIF ID m2.

data: i_raw TYPE truxs_t_text_data.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

i_field_seperator = 'X'

i_tab_raw_data = i_raw

i_filename = p_local

TABLES

i_tab_converted_data = i_file_data[]

EXCEPTIONS

conversion_failed = 1

OTHERS = 2

IF sy-subrc 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF. " sy-subrc