OTF data to Excel

[former_member185848]

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.

<b>Is there any better way or an potimised way to do this ?</b>

Thanx and regards,

Raj

Message was edited by: krishnaraj Baskar

[former_member185848]

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.

<b>Is there any better way or an potimised way to do this ?</b>

Thanx and regards,

Raj

Message was edited by: krishnaraj Baskar

[Former Member]

Hi Baskar,

If your requirement is to mail then FM <b>CONVERT_OTF_AND_MAIL</b> will do the trick,

But, to download onto the local PC

FM CONVERT_OTF and

FM GUI_DOWNLOAD will do.

Regards,

Raj

[former_member185848]

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

[Former Member]

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

[Former Member]

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

[former_member185848]

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.

[Former Member]

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 <b>STXW</b>.

Regards,

Raj