topic Re: Fetch Excel sheet records to a function module?? in Application Development and Automation Discussions

Fetch Excel sheet records to a function module??

Former Member — Wed, 29 Dec 2010 05:38:07 GMT

Dear Experts,

I have a small requirements, i have a function module with 4 input parameters ( I_LIFNR,I_MATNR,I_EKORG,I_WERKS). The requirement is User will upload his excel sheet with this 4 values, the function module should fetch the records from the excel sheet and do the remaining functionality.

So how to get the excel sheet records or how to upload the excel sheet records to this function module or to this input parameters?

Anyone can guide me?

Mohana

Re: Fetch Excel sheet records to a function module??

Former Member — Wed, 29 Dec 2010 05:44:13 GMT

Hi,

Use TEXT_CONVERT_XLS_TO_SAP to download the data from excel to some internal table.

loop at this internal table into workarea and call your FM with 4 input parameters ( I_LIFNR,I_MATNR,I_EKORG,I_WERKS) .

Pass the work area values accordingly and carry on with your code for other fuctionality.

BR,

Lokeswari.

Re: Fetch Excel sheet records to a function module??

amit_khare — Wed, 29 Dec 2010 05:46:27 GMT

You cannot.

Either write a wrapper program on your FM to upload Excel and pass value to it or change your FM for the requirement.

Re: Fetch Excel sheet records to a function module??

Former Member — Wed, 29 Dec 2010 06:59:38 GMT

A function module cannot directly fetch data from an excel file. You will have to code it.

There are two ways you can code this.

Option 1 :

Add another input parameter in the function say 'filename'.

call FM GUI_UPLOAD to upload the excel file into an internal table.

Option 2:

Create a wrapper program for this function module which provides an input for the file name.

Again use GUI_UPLOAD to upload the file in the program.

Regards,

Jovito.

Re: Fetch Excel sheet records to a function module??

Former Member — Wed, 29 Dec 2010 08:02:11 GMT

Use this FM : ALSM_EXCEL_TO_INTERNAL_TABLE to upload the data from excel.

Re: Fetch Excel sheet records to a function module??

Former Member — Wed, 29 Dec 2010 08:02:20 GMT

Best is to Use the FM TEXT_CONVERT_XLS_TO_SAP

It stores the excel data into an internal table.

Now loop through that internal table and feed the data accordingly to the FM which you needed to pass the data.