Format Options in Excel

Former Member — Mon, 24 Sep 2007 04:09:49 GMT

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.

Although iam using the method 'set_format' , iam not sure how to use this to format CURR values ??

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 for PC

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.

Re: Format Options in Excel

Former Member — Mon, 01 Oct 2007 07:41:08 GMT

This problem is solved.

topic Format Options in Excel in Application Development and Automation Discussions

Format Options in Excel

Re: Format Options in Excel