topic Re: Excel to internaltable in Application Development and Automation Discussions

Excel to internaltable

Former Member — Mon, 25 Jun 2007 11:32:54 GMT

Hi,

Could anybody tell me, if I have the number of sheets in the excel sheet, then how can I upload the data from excel sheet to internal table.

Thanks,

bsv,

Re: Excel to internaltable

seshatalpasai_madala — Mon, 25 Jun 2007 11:34:08 GMT

Hi,

Check the FM

HR_PK_EXCEL_TO_INTERNAL_TABLE.

Regards,

Sesh

Re: Excel to internaltable

Former Member — Mon, 25 Jun 2007 11:39:58 GMT

Hi Bsv,

Just chk this sample code.

TYPE-POOLS truxs.

types: begin of t_tab,

col1(5) type c,

col2(5) type c,

col3(5) type c,

end of t_tab.

data : itab type standard table of t_tab,

wa type t_tab.

data it_type type truxs_t_text_data.

parameter p_file type rlgrap-filename.

data ttab type tabname.

at selection-screen on value-request for p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

PROGRAM_NAME = SYST-CPROG
DYNPRO_NUMBER = SYST-DYNNR

FIELD_NAME = 'P_FILE'

IMPORTING

FILE_NAME = p_file

start-of-selection.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =
I_LINE_HEADER = 'X'

i_tab_raw_data = it_type

i_filename = p_file

tables

i_tab_converted_data = itab[]

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.

end-of-selection.

loop at itab into wa.

write : wa-col1.

write : wa-col2.

write : wa-col3.

endloop.

Thanks,

reward If Helpful.

Re: Excel to internaltable

Former Member — Mon, 25 Jun 2007 11:40:55 GMT

Hi,

FM: <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b> will help.

Thanks and Regards,

Kunjal Patel