Excel format without using the macro to format the output

[Former Member]

Hi,

I wish to display the output of the report in the excel format without using the macro which is used to format the excel sheet output.

I know there is a Function Module" RH_PM_EXCEL_COMMUNICATION " for this but i am not aware how to use this function module for doing this this.

Actually there is a requirement in which earlier for this type of output they use to save the file in Unix download thie file to computer and they use to run a macro to format the excel file in the required format but now they dont want to do this lengthy process they directly wanted in the output.

without downloading and running the macro is the excel sheet.

the wanted the result directly in the spool.

Could you please reply to this query as it is very important.

Thanks in advance.

[former_member1259992]

Hi Poonam,

Take a look at function module WS_EXCEL.

You can give it a file path and load your data in the table, and it will generate a spreadsheet.

I think the SYNCHRON parameter affects whether it opens the spreadsheet immediately.

You may need to experiment a little, but it could help.

Regards

Robin