topic Re: Dynamic internal for uplaoding diff excel sheets data in Application Development and Automation Discussions

Dynamic internal for uplaoding diff excel sheets data

Former Member — Wed, 02 Dec 2009 13:56:44 GMT

Hi all,

I am uploading different excel data into SAP. I want to use one internal table for 3 excel sheets data . I know how to upload the data using the fucntion module ALSM_EXCEL_TO_INTERNAL_TABLE.

I will upload only 1 excel sheet every time.

regards,

Ajay

Re: Dynamic internal for uplaoding diff excel sheets data

Former Member — Wed, 02 Dec 2009 14:07:40 GMT

Hi Ajay,

It would be better if you could merge them into an excel sheet with multiple worksheets & then upload them using OO ABAP concept.

Refer below link :-

[http://wiki.sdn.sap.com/wiki/display/Snippets/ReadmultiplesheetsofanExcelfileintoSAPthroughABAP]

Regards

Abhii

Re: Dynamic internal for uplaoding diff excel sheets data

Former Member — Wed, 02 Dec 2009 14:28:08 GMT

Hi Abhi,

I will upload only one excel data at a time . I have 3 different types excel data.

For example :

1 st excel sheet having 2 fields,

2 nd excel sheet having 4 fields,

3 rd excel sheet having 6 fields.

Instead of using every time the same function module, How can write that Subroutine to use diffent structures.

regarsds,

Ajayreddy

Edited by: Ajay reddy on Dec 2, 2009 3:51 PM