on 04-25-2012 10:37 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.