Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

i_oi_spreadsheet->set_ranges_data problem?

Former Member

‎03-10-2010 6:44 AM

0 Kudos

Hi all,

My code follows:

  • -----------------------------------------------------------------------------*

  • Build ranges table

  • -----------------------------------------------------------------------------*

clear: wa_range.

wa_range-name = 'range1'.

wa_range-rows = 3.

wa_range-columns = 2.

wa_range-code = 1.

append wa_range to lt_ranges.

clear: wa_range.

wa_range-name = 'range2'.

wa_range-rows = 4.

wa_range-columns = 2.

wa_range-code = 1.

append wa_range to lt_ranges.

  • -----------------------------------------------------------------------------*

  • Build contents table

  • -----------------------------------------------------------------------------*

clear: wa_content.

wa_content-col1 = 'a1'.

wa_content-col2 = 'b1'.

append wa_Content to lt_contents.

...

clear: wa_content.

wa_content-col1 = 'a7'.

wa_content-col2 = 'b7'.

append wa_Content to lt_contents.

  • -----------------------------------------------------------------------------*

  • Build range names table

  • -----------------------------------------------------------------------------*

wa_range_name-name = 'range1'.

wa_range_name-top = 1.

wa_range_name-left = 1.

wa_range_name-rows = 3.

wa_range_name-columns = 2.

append wa_range_name to gt_range_name.

CLEAR: wa_range_name.

wa_range_name-name = 'range2'.

wa_range_name-top = 7.

wa_range_name-left = 1.

wa_range_name-rows = 4.

wa_range_name-columns = 2.

append wa_range_name to gt_range_name.

  • -----------------------------------------------------------------------------*

  • Write to excel file

  • -----------------------------------------------------------------------------*

call method g_spreadsheet->insert_ranges

exporting

ranges = gt_range_name

IMPORTING

ERROR = g_error

RETCODE = g_retcode

.

call method g_spreadsheet->set_ranges_data

exporting

ranges = lt_ranges

contents = lt_contents

IMPORTING

error = g_error

retcode = g_retcode.

  • ------------------------------------------------------------------------------*

But only data of range1 is written to excel while data of range2 is missed.

(g_retcode = 'OK' -> excel export successfully).

I don't know why.

Could you pls help me?

Thanks and regards,

Hung.

1 REPLY 1

Former Member

‎03-10-2010 11:36 AM

0 Kudos

Hi,

dont pass value for wa_range_name-top and wa_range_name-left.

Try now.

regards,

shanmugavel chandrasekaran