topic Re: Create an Excel File in background in Application Development and Automation Discussions

Create an Excel File in background

Former Member — Thu, 10 Jan 2008 03:02:56 GMT

Ladies and Gentlemen,

I have a requirement to create an Excel file in a program that will only be executed in background mode. This automatically rules out GUI_DOWNLOAD or any download funtion that presents the file on the presentation server.

I think that the 'Open Dataset...' command will work to create the file on the Application server, but this seems a bit archaic to me. Is there another way of creating the excel file on the application server in background? I am working on a 4.7 system at the moment, but this is scheduled for a upgrade to ECC6 sometime in the next 12 months, so I'm after a process that will be valid both before and after the upgrade.

Cheers,

Steve

Re: Create an Excel File in background

Former Member — Thu, 10 Jan 2008 03:19:29 GMT

Hi,

Not sure you can give a try using FTP_COMMAND.

But I don't think it works for excel sheet.

Open Dataset ("OLD IS GOLD")

Thanks,

chaithanya K

Re: Create an Excel File in background

former_member189059 — Thu, 10 Jan 2008 03:25:51 GMT

Hello Stephen,

I think the best option is to manually format the output into the CSV format

ie: add commas between your output fields

then using open dataset, you can write a CSV file to the application server which will open in excel automatically

Re: Create an Excel File in background

Former Member — Thu, 10 Jan 2008 04:30:52 GMT

Hi Stephen,

Use Open dataset, Transfer, Close dataset to create file on Application server.

Use FM Z_CONV_ITAB_TO_TAB_DELIMITED to convert your lines in TAB delimited format. you can download file from your application server to presentation server using T Code CG3Y and give extension as .xls ...

As you data is Tab delimited it will automatically get formatted in columns in your EXCEL file.

Regards,

Mohaiyuddin

Re: Create an Excel File in background

Former Member — Thu, 10 Jan 2008 04:58:22 GMT

Hi,

Check the following link:

http://sap-img.com/abap/download-in-background-in-excel-format.htm

Regards,

Bhaskar

Re: Create an Excel File in background

Former Member — Thu, 10 Jan 2008 05:12:12 GMT

Hi Stephen,

Give me your email address, I will send you a document with the logic and a detailed explanation...

-Muktar