Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

OTF data to Excel

0 Likes
1,021

Hi,

Iam converting OTF format to excel

1) OTF to ASCII (using Convert_to_otf)

2)ASCII to Excel.

when I download data to excel the alignment of the data goes wrong.

Thanks and Regards

Krishna

Hi,

Iam converting OTF format to excel

1) OTF to ASCII (using Convert_to_otf)

2)ASCII to Excel.

when I download data to excel the alignment of the data goes wrong.

Thanks and Regards

Krishna

5 REPLIES 5
Read only

Former Member
0 Likes
799

Hi Baskar,

Chcek between these two steps, if the alignment is proper oafter the first step itself.

If not, align it properly after the first step itself and then do the ASCII to EXcel part.

Regards,

Ravi

Read only

Former Member
0 Likes
799

Hi Baskar,

Checkout these FMs

CONVERT_OTF_2_PDF

SX_OBJECT_CONVERT_OTF_PDF

SX_OBJECT_CONVERT_OTF_PRT

SX_OBJECT_CONVERT_OTF_RAW

Regards,

Raj

Read only

Former Member
0 Likes
799

Hai Baskar,

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

If you want to download onto the local PC

FM <b>CONVERT_OTF</b> and

FM <b>GUI_DOWNLOAD</b> will do.

Regards,

Srikanth.

Reward points if helpful.And close the thread.

Read only

Former Member
0 Likes
799

alignment of the data goes wrong.

what does this mean ?? any indentation problem or what ?

pl elaborate...

regards

Srikanth

Read only

0 Likes
799

Hi All,

Iam trying convert OTF data basically from Smartform output which is exactly what I required came out perfectly in case of PDF and the same I am trying to do the same in excel the indentation and the alignment goes wrong is not same as Smartform output.

Thanks

Krishna