Download to XL

[Former Member]

Hello ALl,

I want to download the results of my page which r in a table into XL.

• I'm not using MVC model

• In future i have to convert the same into MVC so i don't want to use scripting also.

please provide me a proper path to proceed.

Waiting for ur reply........

Regards,

Deepu.K

[Former Member · Accepted solution]

Hello Kumar and Chinnasamy,

Thanks for ur help.I've gone thru the blogs and i think this must work for me.

If it doesnot work i'll catch u guys.......(: (:

I've assigned points to both of u.

be in touch.

Regards,

Deepu.K

[Former Member · Accepted solution]

Hello Kumar and Chinnasamy,

I'm back with a querry in the download weblog.

1, In the blog : in the PAGE CODING section :

<ZKEG:downloadTableExcel id = "DOWNLOAD"

disabled = "<%=model->download_disabled %>"

display_url = "<%= application->display_url %>" />

what is the type of the <b>model</b> and

<b>applicatio</b>n ?

2, As i told u before i'm not using the MVC model.

After the PAGE CODING section in the blog there is

<b>DO_HANDLE_EVENT</b> of the controller class.

AS i'm not using the controller class where should i

write the code for his ?

3, In this method the variables are declared like this :

<b>data: model type ref to zcl_bsp_m_mxref_query.

data: appl type ref to zcl_em_bsp_appl_mat_xref.</b>I don't have the classes <b>zcl_bsp_m_mxref_query and

zcl_em_bsp_appl_mat_xref</b> .

what should i do for this ?

4, where must the methods <b>PROCESS_XLS_DOWNLOAD,html,xml</b> code written ?

please send me a <b>sample code</b> if u have implemented this download option in ur application.

Consider this as very <b>urgent</b> issue ................

Regards,

Deepu.K

[former_member194147 · Accepted solution]

Hi Deepu,

1.Since you are not using MVC model and application here. Simply use any global variable. The same code you can write in this manner:

<ZKEG:downloadTableExcel id = "DOWNLOAD"

disabled = "<%= gv_dload %>" display_url = "<%= gv_url %>" />

where gv_dload and gv_url are global variables.

2.The coding written in DO_HANDLE_EVENT should be written in ON_INPUT_PROCESSING.

3.Instead of writing this you can write just this piece of code:

if event_id cs 'DOWNLOAD'.

data itab type ref to data.

get reference of <your_itab> into itab.

gv_url = = zcl_es_bsp_elmnt_dwn_tbl_excl=>handle_event(

htmlb_event_ex = htmlb_event_ex

runtime = runtime

itab = itab ).

endif.

4. You should write that code in the element handler class of the BSP Extension i.e in ZCL_ES_BSP_ELMNT_DWN_TBL_EXCL

Regards

Dhannajay

If helpful, kindly assign points.

[Former Member · Accepted solution]

Hello Dhananjay,

Thanks for your input.

It's working .

But there is a problem with error handling in downloading.

As of now i commented that error handling code.I'll tale up that work later.

Anyways thank's once again.

Now i have to try for the Hierarchical list in the table view as per ur advice in the other blog.

I'll try that now and in case if any difficulty i shall knock you back.

Regards,

Deepu.K

[former_member194147]

Hi Deepu,

I had the similar requirement what u have stated.

Kindly go to the following link.

/people/thomas.jung3/blog/2004/09/02/creating-a-bsp-extension-for-downloading-a-table

This is the best solution I found for this issue.

If useful kindly assign points

[Former Member]

Hi deepu,

Please check below weblogs, which may help you for your requirement.

/people/thomas.jung3/blog/2004/09/02/creating-a-bsp-extension-for-downloading-a-table

/people/thomas.jung3/blog/2005/07/18/bsp-extension-for-downloading-a-table-applying-an-iterator

/people/thomas.jung3/blog/2005/02/23/bsp-and-microsoft-excel--learning-to-live-together-part-2

Thanks!

Lakshmikandh