set_format in Excel interface

[Former Member]

Hello All,

Iam exporting data from ABAP screen to Excel using methods of interface 'I_OI_SPREADSHEET'. I have currencies which is in the format '100,00-' etc. But in Excel these values are not transported . I have pasted a part of my code. Pls Help.

wa_cell_data-row = i.

wa_cell_data-column = j.

wa_cell_data-value = val.

APPEND wa_cell_data TO gt_cell_data

CALL METHOD g_handle->set_format

EXPORTING

rangename = 'RANGE8'

typ = -1

currency = ' '

no_flush = ' '

decimals = 2

IMPORTING

retcode = retcode.

CALL METHOD g_handle->set_ranges_data

EXPORTING

ranges = range_list

contents = gt_cell_data

IMPORTING

retcode = retcode.

[Former Member]

Solved