set_format in Excel interface

Former Member — Tue, 21 Aug 2007 08:27:12 GMT

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.

Re: set_format in Excel interface

Former Member — Mon, 01 Oct 2007 07:43:22 GMT

Solved

topic set_format in Excel interface in Application Development and Automation Discussions

set_format in Excel interface

Re: set_format in Excel interface