Hello All,
Iam using 'i_oi_spreadsheet' concept to transfer data from screen to an Excel.
I have used the following code to populate a part of my data but i face formatting problems ( EX: the values are not transferred in the format of the installed excel (here: english/american), but with the german number format (e.g. 1.000.000,00 insteadof 1,000,000.00).
This makes a further processing impossible. Kindly help.
DATA:
wa_cell_data TYPE soi_generic_item.
wa_cell_data-row = i1.
wa_cell_data-column = j1.
WRITE val TO wa_cell_data-value LEFT-JUSTIFIED.
APPEND wa_cell_data TO gt_cell_data.
range_item-name = 'RANGE3'.
range_item-rows = '16'.
range_item-columns = '2'.
range_item-code = g_handle->spreadsheet_unprotect.
APPEND range_item TO range_list.
CALL METHOD g_handle->set_selection
EXPORTING
left = 1
top = 9
rows = 16
columns = 2
IMPORTING
retcode = retcode.
CALL METHOD g_handle->insert_range
EXPORTING
columns = 2
rows = 16
name = 'RANGE3'
IMPORTING
retcode = retcode.
CALL METHOD g_handle->set_format
EXPORTING
rangename = 'RANGE3'
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.
Bluesky
