topic Re: Transfer excel to application Server in Application Development and Automation Discussions

Transfer excel to application Server

Former Member — Sat, 28 Jan 2012 10:08:54 GMT

Dear SAP Gurus,

I am currently using OLE application to create an excel sheet as per client requirements. But the method 'SaveAs' can only save the sheet on presentation layer. I need to save this excel sheet to application server. If I give a Presentation layer path the excel sheet gets successfully saved. but I am not able to save it on application server.

I am avoiding OPEN DATASET as this does not store data excel format.

With Regards,

Sulabh Agrawal

Re: Transfer excel to application Server

Former Member — Sat, 28 Jan 2012 12:22:11 GMT

once your file is on presentation server then you can use ARCHIVFILE_CLIENT_TO_SERVER to upload it to application server and delete the file on presentation server, or you may check with the business if they are ok with a csv file then upload it to application server directly.

Re: Transfer excel to application Server

Former Member — Sat, 28 Jan 2012 12:24:41 GMT

hi ,

can u provide me some code to do that..

thanks in advance..

With Regards,

Sulabh

Re: Transfer excel to application Server

Former Member — Sat, 28 Jan 2012 12:34:20 GMT

ARCHIVFILE_CLIENT_TO_SERVER is a simple fm just pass source path n target path.

for csv files you can use open dataset.

Re: Transfer excel to application Server

Former Member — Sat, 28 Jan 2012 12:57:17 GMT

Hi Kartik,

in the function module I have passed:

in path: C:\1.xlsx

in target path: /usr/sap/DEV/SYS/global/1.xlsx

when i execute it. system is giving me error that

Error in opening file /USR/SAP/DEV/SYS/GLOBAL/1.XLSX for writing (No such file or directory)

but when i check in al11 the directory /USR/SAP/DEV/SYS/GLOBAL is available on application server.

kindly help me for the same.

With Regards,

Sulabh

Re: Transfer excel to application Server

Former Member — Sat, 28 Jan 2012 13:16:44 GMT

can you try this: EPS_FTP_PUT

i'm not on sap right now so cant validate now.