View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default Stuck at Trying to Extract Data from a Website using JSP

On Jul 26, 10:04*am, ron wrote:
On Jul 26, 7:24*am, "HC" wrote...snip...

So do you know how I
can access the value displayed in the popped up orange box?


HC...The following url produces the original webpage and pop-up box
for flat 26/F A

http://proptx.midland.com.hk/unit/in...05&unit_id=U00....

If you programatically select all and copy / paste as text into an
Excel spreadsheet, the pop-up box info that you want will be found
near the top of the excel sheet...Ron


So just to be clear, all of the flats that have a pop-up window have a
unit ID which can be extracted from the source code (div id=) at

http://proptx.midland.com.hk/unit/in...?est_id=E00005

and assigned to an array. It sounds like HC has already collected all
of these unit IDs.

They can then be programatically added to the base url to create the
link I attached in my earlier post

my_url = base url + unit ID
= "http://proptx.midland.com.hk/unit/index.jsp?
est_id=E00005&" _
ID_array(J)

One can then step through these urls one at a time and open the web
page plus pop-up window for each url; scrape each window plus pop-up,
paste the contents into excel and extract the desired information that
was contained in the pop-up window...Ron