Transfer excel to application Server

[Former Member]

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

[Former Member]

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.

[Former Member]

hi ,

can u provide me some code to do that..

thanks in advance..

With Regards,

Sulabh

[Former Member]

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

for csv files you can use open dataset.

[Former Member]

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

[Former Member]

can you try this: EPS_FTP_PUT

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