Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Excel File to App Server using OLE

Former Member
0 Likes
565

I have a program in which I am creating Excel output via OLE. It works great! But my users need to run the program in the background. When running in the background, I cannot output to a local file. Is there a way to output my Excel sheet to the App Server using OLE?

I have seen posts where I can use the 'Transfer' command to put it on the app server like I would for any other file, but in doing this my formatting is not passed.

Is there anything I can do?

Thanks,

Mary

I have a program in which I am creating Excel output via OLE. It works great! But my users need to run the program in the background. When running in the background, I cannot output to a local file. Is there a way to output my Excel sheet to the App Server using OLE?

I have seen posts where I can use the 'Transfer' command to put it on the app server like I would for any other file, but in doing this my formatting is not passed.

Is there anything I can do?

Thanks,

Mary

1 REPLY 1
Read only

former_member194669
Active Contributor
0 Likes
486

Try to create XLS using XML tags,

https://www.sdn.sap.com/irj/scn/wiki?path=/display/snippets/xmlTAGSsimplifiesExcelDownload