Import data from Web Page problem - .jsp table

[bezwlosy]

Hello,

I have a problem in importing a table from a website to my excel file.
I use the automatic way build in Excel.

The problem is that the table is well imported to Excel, with the headers and rows, but the data is not. I suppose this is because this data is created by .jsp script on the webpage, therefore it is not copied by Excel.

Do I need to create some macros, or this way is still good if I change something?

Webpage is: http://en.sse.net.cn/indices/scfinew.jsp and I need current index date and value.

Thank you for any hint.
Best regards,

[Norie]

The table is just a standard HTML table as far as I can see, how are you trying to import it?

[bezwlosy]

Hi Norie, thank you for help.
What I am doing is (Excel 2007):
Data > Import data from Web Page > then in the window that appears I'm entering the www address and I choose the right table > then I click Import and I choose the cell to insert data.
By doing this, the table is imported, but without the data in the columns Previous, Current and Compare. Neither the dates under Previous and Current show.
It is empty apart from headers and first 3 columns.

While the webpage is being loaded in the normal browser, I can see these data are filled after - it seems to me like they are created by the script.

How do you see it?

Thanks!

[bezwlosy]

Someone already helped me. It is not a static data on this webpage, so we need to retrieve it from a server - the above method will not work.