08-05-2014 10:25 AM
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,
08-05-2014 10:52 AM
Hi
Pass value 1 for import parameter UPDATING in the method get_ranges_names.
Regards
Raj
08-05-2014 12:02 PM
Hi Raj,
i doesn't solve my problem. It showing still now that it contain only 32 column.
regards,
Dami
08-05-2014 2:04 PM
Problem is solved. Excel template created new and uploaded. Now the ranges are read correctly