cancel
Showing results for 
Search instead for 
Did you mean: 

Using the Feature "Import from Web" in excel from webdynpro report URLs

Dileep_Venugopa
Associate
Associate
0 Kudos

Hi,

There is a feature in excel where you can import the data from web by giving the web URL and the excel would fetch the data from web into excelsheet. And there is a button called "Refresh" in excel using which you can get the latest data on the web into excel anytime by just clicking on that button.

when I try to fetch the data with the Webdynpro URL am not able to fetch tat data into the excel.

If anyone of you worked on any similar requirement please do give your suggestions.

Thanks a lot.

Regards,

Dileep

Accepted Solutions (0)

Answers (1)

Answers (1)

chengalarayulu
Active Contributor
0 Kudos

Hi Dileep,

so, you are using button UI element. if you use this, the URL calling should be in External Window, hope you are doing same.

or else, it should be LinkToUrl(assign your URL in reference property), if your path refers directly to the excel document, surely it will gives a popup asking open/save/cancel.

Dileep_Venugopa
Associate
Associate
0 Kudos

Hi chengalarayulu,

Guess you dint get the question right..I wanted to make the webdynpro URL compatable to use the "import from web" feature of MS excel.

Thanks anyway..

Regards,

Dileep

former_member199125
Active Contributor
0 Kudos

Is your webdynpro url works in internet?  or in VPN ?

Regards

Srinivas

Dileep_Venugopa
Associate
Associate
0 Kudos

Hi  Srini,

It works in both...

Former Member
0 Kudos

Hi dileep,

Which version of excel you are using. Are you talking about the option that i have shown in the picture added or something else from newer versions?

Dileep Venugopal wrote:

when I try to fetch the data with the Webdynpro URL am not able to fetch tat data into the excel.

Whats the result? error or no data returned.

Regards,

Fareez

Dileep_Venugopa
Associate
Associate
0 Kudos

Hi Fareez,

I am using MS excel 2007. Guess am trying to use the same feature you have mentioned in 2007 version.

This is the output I get :

["sap.client.SsrClient.form", "_loadingPlaceholder_", "sapwd_main_window_root_", "IHUB"]

Former Member
0 Kudos

Hi dileep,

I think it cannot be done. Webdynpro does not generate static pages which contains all the information that need to be shown in the HTML alone. It sends some Javascript to the client, and that javascript is loading the necessary data through ajax. So the data exists in the DOM tree and not in the response. Excel seems to be processing the response to get the data, It does not seems to get data by processing the DOM tree.

Regards,

Fareez