Excel VBA web scaping element challenge -


i trying collect pricing data travel website.

below html , want retrieve number 2145.66 , put in excel cell.

<ul class="hotelresults">   <li class="image"><img src="http://images.libertytravel.com/shared/cpl/fcl/images/upload/suppliers/h/aua/rem/img_148208_medium.jpg" width="120" onerror="this.src='/images/book.libertytravel.com/no-pic.gif';"></li> <li class="detail"> <h4>renaissance marina hotel &nbsp;<img src="http://static0.traveltek.net/images/book.libertytravel.com/1star.png" alt="star"><img src="http://static0.traveltek.net/images/book.libertytravel.com/1star.png" alt="star"><img src="http://static0.traveltek.net/images/book.libertytravel.com/1star.png" alt="star"><img src="http://static0.traveltek.net/images/book.libertytravel.com/1star.png" alt="star"></h4> <span class="mytime"></span><span class="hotelpref"></span> <h5>aruba</h5> <span id="desc_555_0.1">experience fresh twist on stay , play in stylish, sophisticated atmosphere @ renaissance aruba resort , casino. </span><a href="/fusion/searchsinglehotel.pl?sessionkey=f5afd4b1-782cl4a8b-9b26-ac8eae88c1e5&amp;chosenhotel=555_0.1&amp;chosenflight=617_0.0">see details</a> </li> <li class="price">     <script language="javascript"> event.observe(window, "load", function() {  $$('span.roomprice').each(function(element) {          element.innerhtml = properrounding(element.innerhtml, 2);      });  }); </script>  <table width="100%" cellspacing="0" cellpadding="0" border="0" class="roomsrow">     <tr class="hide">         <td colspan="3" class="sectionheader">             <a href="#" onclick="showmore('hoteldetails'); return false">                 <div id="hotelexpand">                     <div class="plusminus"></div>                 </div> show/hide room selections             </a>         </td>     </tr>     <tr>         <td colspan="3" style="border:none">              <div id="hoteldetails" style="display:none">                  <table width="100%" cellpadding="0" cellspacing="0">                             <tr class="hide">                         <th align="left">room description</th>                         <th align="right">total basket cost</th>                         <th>&nbsp;</th>                     </tr>                     <tr>                     <td colspan="3">                     <script language="javascript"> event.observe(window, "load", function() {  $('rightprice_div_555_0.1_555:0').innerhtml = properrounding('2145.66', 2);

my code follows:

r = 0 c = 0  set tdelements2 = .document.getelementsbyclassname("price") l = tdelements2.length  = 0 l  msgbox (tdelements2.item(i).innertext) msgbox (i) = + 0  sheet2.range("a1").offset(r, c).value = tdelements2.item(i).innertext r = r + 1 c = c + 0 next

however, in not returning rate/number looking for.

any help/suggestions appreciated.


Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

i trying ip address of vm , trying use establish ssh vm. following script: --- - hosts: localhost become: yes connection: local gather_facts: false serial: 1 vars_files: - createvmvars.yml tasks: - name: gathering vm info. vsphere_guest: vcenter_hostname: "{{vcenter_hostname}}" username: "{{vcenter_username}}" password: "{{vcenter_password}}" guest: "{{guest_name}}" vmware_guest_facts: yes register: var - debug: msg="{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" - name: establishing ssh connection. script: /home/shasha/devops/scripts/ssh_configure.sh "{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" following content of ssh_configure.sh : #!/bin/sh ssh-keygen -t rsa ssh-copy-id $1 but when running playbook, getting following error while executing third task: error! 'var' undefined but debug module(second task) printin
Read more

javascript - Get parameter of GET request -

i make request: createxhrrequest( "get", fileurl, function( err, response ) { if( err ) { alert( "error get!" ); } alert(response); }); and full response: { "status" : "ok", "message" : "jvberi0xljqkjdduxdgkmy how can jvberi0xlj ? i try response.message , response["message"]. nothing works. just simple access this: var json = json.parse(response); json.message
Read more