Set_Format in Excel and Curr code

[Former Member]

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]

Hi Sri,

Please check the link -:)

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCIOFFI/BCCIOFFI.pdf

Thanks and Best Regards,

Vinoth

[Former Member]

Hello Vinoth,

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