Excel Download OLE2

[Former Member]

Hi Everybody,

I want to download the Excel sheet using the OLE2 methods in the Background i,e. when SY-BATCH = 'x'.

Is there a way to do that?

Can someone tell me how to do that?

Please help.

Thanks,

Shashi Devi.

[Former Member]

hi,

Check out the below related threads ... Hope it helps

[Former Member]

check

https://forums.sdn.sap.com/click.jspa?searchID=12326889&messageID=1745808

Regards

Kiran Sure

[Former Member]

Kiran,

Will this work for OLE2 mathods as well?

Thanks,

Shashi Devi

[naimesh_patel]

As Eric pointed, there is no way that you can download the excel in background.

The workaround would be:

1. Download your file on the application server when the program is running in background.

2. When the Job is finished read the file from the server and use the OLE or other FMs to download the file to the presentation server (PC).

Regards,

Naimesh Patel

[Former Member]

Naimesh,

I am trying to create a RFC Destination to make the Application Server talk to Presantation server in the Background.

Wont it work then?

Thanks,

Shashi Devi.

[Former Member]

The actual requirement I have is that ,

I am uploading an Excel sheet and trying to modify some fields and download it again.

The Excel sheet has lot of Formats and pictures in it.

Is there some way to upload the format of the excel sheet as well?

[JozsefSzikszai]

Shashi,

I already pointed out: there is no way. In background there is only Application Server, nothing else. No Presentation server, no network, etc...

On the other hand if you want only to modify few fields in an Excel file, why don't you do it directly in Excel?

ec

[Former Member]

Eric,

Have a look at this link once

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9831750a-0801-0010-1d9e-f8c...

[JozsefSzikszai]

thanks Shashi!

I hope you noted the point:

"Before running the program first we need to run the rfcexec in the command prompt passing parameters u2013a<program ID> -g<SAP Host> -x<SAP GatewayService>."

Which simply means this is not real background mode (from functionality point of view).

You also has to define each single desktop (where you want to use this) as RFC destination.

[JozsefSzikszai]

hi Shashi,

It does not matter how many links are provided by others , there is no way to download in background in Excel format .

In background there is no presentation server (i. e. the PC you are sitting front of), while the OLE methods (which you need for downloading in Excel format) are uploaded from the presentation server (during the download prcess).

hope this helps

ec