Excel to Internal Table Issue

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

did you try function call function 'ALSM_EXCEL_TO_INTERNAL_TABLE' ?

Fred

[Former Member]

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.

[rosenberg_eitan]

Hi,

Assuming  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

See

Regards.

[Former Member]

Thank you all for your valuable suggetions..

i am using the function module ' TEXT_CONVERT_XLS_TO_SAP'.

it is working fine