PDA

View Full Version : Importing data from script-based web pages



alinagoo
12-06-2013, 10:26 AM
Hello all

I have a question. Could you help me?
My question is how to import data from a Non-HTML web page to an Excel worksheet. the web page shows many fields to the user but these fields are not in the form of HTML and they are not visible/unclosed so "Get external data" facilities of Excel are not able to read/extract the fields. is there any way to extracting data from these scripts-based web pages?

Thanks & Good Luck:cool:

Sample Code page is as follow:



<!doctype html><html><head><meta http-equiv="X-UA-Compatible" content="IE=edge"><title>.:TSETMC:. :: اطلاعات نماد</title><script>function ens(ty,sv){var lv=localStorage.getItem("v_"+ty);var t;if (lv==null || lv!=sv){var oX=new XMLHttpRequest();oX.open('GET', 'tsev2/res/loader.aspx?t='+ty+'&_'+sv,false);oX.send(null);t=oX.responseText;if(t[t.length-1]!=';') return;localStorage.setItem("v_"+ty,sv);localStorage.setItem("t_"+ty,t)}else{t=localStorage.getItem("t_"+ty)}if (ty=='s'){document.write("<style>"+t+"</style>")}else{var h=document.getElementsByTagName('HEAD').item(0);var s=document.createElement("script");s.defer=true;s.text=t;h.appendChild(s)}}var version='256';ens('j',version); ens('s',version);</script></head><body><div style="display:none">PSB is being developed by Pooya Paridel.</div><div id="FastView" class="slideTop"></div><div id="pulldown" class="close"><div id="opacity"></div><div style='height:340px'></div><div id="company"><div id="company_logo"></div><div id="company_text">شركت مديريت فناوري بورس تهران <br/>TSETMC</div></div><div id="menu_btns"></div><script>ShowMenuIcon(0)</script></div><div class="MainContainer"><form name="form1" method="post" action="Loader.aspx?ParTree=151311&amp;i=23441366113375722" id="form1">
<input type="hidden" name="__VIEWSTATE" id="
__VIEWSTATE" value="" />

<script>var LVal18AFC='پارسان',CgrValCot='N1',Flow='1',InstrumentID='IRO1PASN0001',InsC ode='23441366113375722',BaseVol=3000000,EstimatedEPS='2001',ZTitad=10000000 000,CIsin='IRO1PASN0004',LVal18AFC='پارسان',CSecVal='44 ',PdrCotVal='',PClosing='',PSGelStaMax='15327.00',PSGelStaMin='14149.00',Ti tle='گسترش نفت و گاز پارسيان (پارسان) - بازار اول (تابلوي فرعي) بورس',MinWeek='13400.00',MaxWeek='15327.00',MinYear='6030.00',MaxYear='1532 7.00',QTotTran5JAvg='11807819',SectorPE='8.47',KAjCapValCpsIdx='16',PriceMi n=0,PriceMax=0,PriceYesterday=0;</script>

<div id="tabs" class="InsInfoTab"></div>
<div id="MainBox" class="box1 zFull silver">
<div id="MainContent" class="tabcontent content">

alinagoo
12-06-2013, 09:50 PM
sample web page:
tsetmc.com/Loader.aspx?ParTree=151311&i=63917421733088077