topic Re: Set_Format in Excel and Curr code in Application Development and Automation Discussions

Set_Format in Excel and Curr code

Former Member — Tue, 25 Sep 2007 05:51:31 GMT

Hello Abapers,

Iam using 'I_OI_SPREADSHEET' concept to export data from screen to Excel.

Iam using the method 'SET_FORMAT' to set diff formats as my data includes

(CURR , Texts etc). But , iam not sure how to use this method for CURR?

Below is a part of my code:

CALL METHOD g_handle->set_format

EXPORTING

rangename = 'RANGE3'

typ = -1

currency = ' '

no_flush = ' '

decimals = 2

IMPORTING

retcode = retcode.

Could any one give me an idea as to wht to/ How to pass for this param currency ? Any example code wud be appreciated.

Thanks,

Sri

Former Member — Tue, 25 Sep 2007 06:39:31 GMT

Hi Sri,

Please check the link -:)

Thanks and Best Regards,

Vinoth

Former Member — Tue, 25 Sep 2007 07:23:46 GMT

Hello Vinoth,

Thanks for the link but even there it doesn't clearly specify how CURR fields shld be handled.