Importing and exporting exel file in the SAP report

[Former Member]

HI All,

I have some queries regarding using the exel in ABAP reports,

1) How to take an exel file as input in ABAP report.

2)Can it be possible to edit the same file in the report.

     e.g The file containing the employee name is given as input to HR report. Can it be possible to fetch the employee details (PERNR,Status etc) and update in the other columns of same file and send the file as out put.

Kindly reply on this is there any way of doing like this.

Regards,

Chetana

[Former Member]

Hello Chetana,

If you are developing the  ABAP Report , you can use FM ALSM_EXCEL_TO_INTERNAL_TABLE  to import the excel sheet , here you will get the excel data into the internal table.

And the modifications of data can be done as per the requirement in internal table and can downloaded as excel file with FM XXL_FULL_API .

[former_member243278]

Hello Chetana,

It is not possible for standard processing. There is no solution about it for now. However, you can develop a program for your needs. It is possible with custom developments but I think, it is not easy to develop and to be stable.

Maybe you should find another way to solve. If you want to help, can you explain your requirements with more details.

[jagan_gunja]

You can use enhancement methods like bADI, user function, ABAP Enhancement (this would be a flexible method I would say, and it is not impacted by OSS notes or support packs; but you may still need to verify if it requires a correction ins such instances),  etc.

In a report that has an Excel output facility, go to System->Status, then navigate to the program and double click to display the program, or display the program directly if you know which program has this capability.  Find out reference/s for Excel to see what code is required.  When you press the Excel button it is termed as a user action, this action triggers a certain part of the code.  You can set a break point and debug the code to understand.

Or simply Google for "SAP Report Excel interface" to find out how.  There must be hundreds of hits.

[venkat_polisetty]

Hi Chetana,

As per knowledge, In standard SAP It is not possible and through custom program it can be done

Regards,

Venkat Polisetty