topic Re: Excel to Internal Table Issue in Application Development and Automation Discussions

Excel to Internal Table Issue

Former Member — Thu, 21 Aug 2014 12:08:33 GMT

Hi Experts,

Row	Column	Value
1	0001	Prem(First Name )
1	0002	Raj(Middle name )
1	0003	Kaushik(Last name )
2	0001	Naresh

I have the above data in excel file and my internal table like as follows

Data : begin of it_itab occurs 0,

Row type c,

Column type string,

Value type string,

End of it_itab.

Now I want to upload the excel file to my internal table
filed wise i.e in my intenal table row
shold have row values from excel same as
for column and value also

Can anyone suggest me fix this issue?

Best Regards,

Ramjee M

Re: Excel to Internal Table Issue

Former Member — Thu, 21 Aug 2014 12:14:33 GMT

Hi,

did you try function call function 'ALSM_EXCEL_TO_INTERNAL_TABLE' ?

Fred

Re: Excel to Internal Table Issue

Former Member — Fri, 22 Aug 2014 09:05:34 GMT

You may use this function to put data in internal table.

CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT'

EXPORTING

filename = p_file *xcel file name

i_begin_col = p_scol *start column

i_begin_row = p_srow *start row

i_end_col = p_ecol *end col

i_end_row = p_erow *end row

TABLES

intern = it_tab

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

Use this function to put data in internal table.

Re: Excel to Internal Table Issue

rosenberg_eitan — Fri, 22 Aug 2014 10:12:38 GMT

Hi,

Assuming CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

See

Regards.

Re: Excel to Internal Table Issue

Former Member — Wed, 10 Sep 2014 11:20:17 GMT

Thank you all for your valuable suggetions..

i am using the function module ' TEXT_CONVERT_XLS_TO_SAP'.

it is working fine