topic Convrting a Script data into excell sheet in Application Development and Automation Discussions

Convrting a Script data into excell sheet

Former Member — Tue, 05 Feb 2008 05:47:00 GMT

Hi Masters,

A very good morning to all,

This is kalyan.

I have doubt on scripts.

How will we convert a script data into spreed sheet (or) Excel sheet or any other.if it possible how?

please put a lights on this issue.kindly give a valuable solutions.

Thanks in advance,

kalyan.

Re: Convrting a Script data into excell sheet

Former Member — Tue, 05 Feb 2008 05:51:32 GMT

If u convert Script to Excel, u will not get the format

So, it is better to convert Script to PDF to get proper format

Narendra

Re: Convrting a Script data into excell sheet

Former Member — Tue, 05 Feb 2008 05:56:02 GMT

Hi Narendra,

Thank u 4 ur valuble solution.

can u post that how we can convert script to PDF .So that i can known how its work.

Thanks & Regards,

kalyan.

Re: Convrting a Script data into excell sheet

Former Member — Tue, 05 Feb 2008 06:06:01 GMT

hi kalyana,

refer to follwinf links

1) to print in PDF

[http://www.sapdevelopment.co.uk/reporting/rep_spooltopdf.htm]

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/49e15474-0e01-0010-9cba-e62df8244556

SAP SCRIPT TO PDF OUTPUT

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/downloadSAPScriptoutputtoPDF+file.&

Function Module: CONVERT_OTF

reward points if helpful

Rohan Malik

Re: Convrting a Script data into excell sheet

Former Member — Tue, 05 Feb 2008 06:06:59 GMT

Hi Kalyan,

u can use these FM to convert your script output to PDF format.

CONVERT_OTF_2_PDF

CONVERT_OTFSPOOLJOB_2_PDF

CONVERT_OTF

thanks,

satheesh

Re: Convrting a Script data into excell sheet

Former Member — Tue, 05 Feb 2008 06:55:26 GMT

Hi,

See script is nothig but a templete. It is possible to convert into PDF. But if u want to convert into excell. First you need to prepare the templete in excell and line items can be downloaded in that excell through program. Define the area in excell for each level. It is possible but little bit tricky.

Regards,

Kumar.