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
Sample Code page is as follow:
HTML Code:<!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&i=23441366113375722" id="form1"> <input type="hidden" name="__VIEWSTATE" id=" __VIEWSTATE" value="" /> <script>var LVal18AFC='پارسان',CgrValCot='N1',Flow='1',InstrumentID='IRO1PASN0001',InsCode='23441366113375722',BaseVol=3000000,EstimatedEPS='2001',ZTitad=10000000000,CIsin='IRO1PASN0004',LVal18AFC='پارسان',CSecVal='44 ',PdrCotVal='',PClosing='',PSGelStaMax='15327.00',PSGelStaMin='14149.00',Title='گسترش نفت و گاز پارسيان (پارسان) - بازار اول (تابلوي فرعي) بورس',MinWeek='13400.00',MaxWeek='15327.00',MinYear='6030.00',MaxYear='15327.00',QTotTran5JAvg='11807819',SectorPE='8.47',KAjCapValCpsIdx='16',PriceMin=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">
Reply With Quote