Trouble with update fields on Excel sheet

[Former Member]

I am currently facing following trouble.

i have added on existing excel template two more fields. But still now it showing that reading fields are 32 instead of 34.

CALL METHOD spreadsheet->get_ranges_names

*     EXPORTING

*       NO_FLUSH = ' '

*       UPDATING = -1

    IMPORTING

      error    = error

      retcode  = h_retcode

      ranges   = lt_rangelist

lt_rangelist is still the old value. How can i solve this problem.

It will be great if someone can help me.

Thanks in advance,

[Former Member]

I am currently facing following trouble.

i have added on existing excel template two more fields. But still now it showing that reading fields are 32 instead of 34.

CALL METHOD spreadsheet->get_ranges_names

*     EXPORTING

*       NO_FLUSH = ' '

*       UPDATING = -1

    IMPORTING

      error    = error

      retcode  = h_retcode

      ranges   = lt_rangelist

lt_rangelist is still the old value. How can i solve this problem.

It will be great if someone can help me.

Thanks in advance,

[Former Member]

Hi

Pass value 1 for import parameter UPDATING in the method get_ranges_names.

Regards

Raj

[Former Member]

Hi Raj,

i doesn't solve my problem. It showing still now that it contain only 32 column.

regards,

Dami

[Former Member]

Problem is solved. Excel template created new and uploaded. Now the ranges are read correctly