topic Re: OTF data to Excel in Application Development and Automation Discussions

OTF data to Excel

former_member185848 — Thu, 09 Mar 2006 13:59:06 GMT

Hi,

Iam convert OTF data to Excel using the FM Convert_otf and the Format ASCII and it returns in internal table of TLINE structure and download it into an local PC using GUI_DOWNLOAD as Format as ASCII.

Is there any better way or an potimised way to do this ?

Thanx and regards,

Raj

Message was edited by: krishnaraj Baskar

Re: OTF data to Excel

Former Member — Thu, 09 Mar 2006 14:13:06 GMT

Hi Baskar,

If your requirement is to mail then FM CONVERT_OTF_AND_MAIL will do the trick,

But, to download onto the local PC

FM CONVERT_OTF and

FM GUI_DOWNLOAD will do.

Regards,

Raj

Re: OTF data to Excel

former_member185848 — Thu, 09 Mar 2006 14:27:49 GMT

Hi Raj,

I have to send the Smartform output both in excel and PDF as email and should not download into the PC as the user doesn't want it

Is it possible to do this ?

Thanx and Regards

Raj

Re: OTF data to Excel

Former Member — Thu, 09 Mar 2006 14:32:28 GMT

Hi,

Do you have any Problem with CONVERT_OTF .

this will convert the OTF and you can download it as excel.

i don't think there is a better option other than this..

Regards

vijay

Re: OTF data to Excel

Former Member — Thu, 09 Mar 2006 14:36:13 GMT

Hi Baskar,

Certainly...

For Excel...

Use FM SX_OBJECT_CONVERT_OTF_RAW and use OLE to write to Excel file.

For PDF

Use FM CONVERT_OTFSPOOLJOB_2_PDF

and mailing...

FM SO_NEW_DOCUMENT_ATT_SEND_API1.

Regards,

Raj

Re: OTF data to Excel

former_member185848 — Thu, 09 Mar 2006 15:13:30 GMT

Hi Raj,

Sorry I forgot to mention here multiple attachment(PDF and Excel)as email.

Iam looking for a FM in such a way it converts OTF both into PDF and Excel and send as an email.

At any point of time it should not download to the local PC.

Re: OTF data to Excel

Former Member — Thu, 09 Mar 2006 15:16:40 GMT

Hi Baskar,

I got ur requirement.

No FM to convert OTF into Excel and PDF, you need to call different FMs for each...

Checkout Function group STXW.

Regards,

Raj