Need help to create one challenging excel macro

[shaikhstonevilla]

Hi Guys,

Thank you so much for reading my post.

I really need your help to create the following excel macro.

I want to get some particular data from the website but unable to get it.

What i do is

1) Go the website www.ebharatgas.com
2) Click on "Transparency Portal" which is available on home page.
3) Then i enter "Gujarat" in the State box, Ahmedabad,Gujarat in the District box and "Vinay Gas Service" in the Bharat Gas Distributor box and click on "Proceed" button.

Now, i want to import this search result into the excel sheet.

I have already tried this by going to the "Data->From Web->Pasted the link but web query says that "There is no data".

Guys, please please help me.


Many thanks in Advance.
Tim Pham

 

[mole999]

you'll need something like this How to Export web page(jsp page) to excel using jsp or servlets or javascript