topic Re: EXCEL in Application Development and Automation Discussions

EXCEL

Former Member — Mon, 09 Jul 2007 06:49:03 GMT

Hi,

I am using XXL_FULL_API function module.

But what is there there are approx. 1.85 records.

So it is exceeding its limit 65536.

Now i want to download that record in EX-CEL.

Now i am planning to divide that record in different EXCEl.

So i am dividing that (record/65536)

And in XXL_FULL_API i am passing itab.

So pls tell me the logic.

Thanks.

Re: EXCEL

Former Member — Mon, 09 Jul 2007 07:33:02 GMT

Hi,

May be you can copy the FM into ZFM and then increase the limit.

Reward if useful!

Re: EXCEL

Former Member — Mon, 09 Jul 2007 07:37:37 GMT

Hi,

i am not getting you.Pls explain in detail.

Thanks.

Re: EXCEL

Former Member — Mon, 09 Jul 2007 07:58:55 GMT

Just Loop around the same FM based on the number of Entries. It will be the easies way.

Regards,

Atish

Re: EXCEL

Former Member — Mon, 09 Jul 2007 08:03:14 GMT

Hi,

Copy this FM to Customized FM through SE37.

Change the value MAX_ROW_XXL_LIMIT TYPE I VALUE 65536.

Reward if useful!

Re: EXCEL

Former Member — Mon, 09 Jul 2007 08:05:14 GMT

Hi Atish,

You are saying like this way.

DESCRIBE TABLE DATA LINES L_DATA.

N = DATA / 65536.

Do n+1 times.

CALL FUNCTION 'XXL_FULL_API'

EXPORTING

n_vrt_keys = 0

n_att_cols = 34

n_hrz_keys = 1

sema_type = 'X'

no_dialog = space

TABLES

vkey = xmplt_v

hkey = xmplt_h

data = itab

sema = xmplt_s

online_text = xmplt_o

print_text = xmplt_p

EXCEPTIONS

file_open_error = 71

file_write_error = 72

inv_winsys = 73

inv_xxl = 74

cancelled_by_user = 75

OTHERS = 99.

CASE sy-subrc.

WHEN 0. "WRITE /'in Ordnung'.

WHEN OTHERS. WRITE: /'Fehler', sy-subrc.

ENDCASE.

ENDFORM.

Pls tell me this is your mean or sth else.

Thanks.

Re: EXCEL

Former Member — Mon, 09 Jul 2007 11:21:45 GMT

Hi,

yes this is what I meant.

Just do it in this way.

Regards,

Atish