Reading external html table on remote server into excel spreadsheet.

[TGWSE_GY]

Ok here is what I need to achieve and if someone could just point me in the direction that I should be looking that would be great.

 

I have a client, that stores data in HTML tables. I am wondering if there is a way to write a php script that would go to say http://www.domain.com/charts/chartid=22 and it grabbed a table that always appears at a fixed point in the source code and process it into a spreadsheet?

 

thanks

 

[sasa]

yes

[TGWSE_GY]

What should I be researching to achieve this then?

[TGWSE_GY]

Can someone at least tell me what the process or function I use in PHP is so that I can figure out how to do this.

 

Thanks

 

[MatthewJ]

Just break it down into parts and Google them... I would start with "scraping data from a webpage with php". Once you get the source code for the table into a variable you will need to decide how you want to parse out the values. this link might help with that http://bytes.com/topic/php/answers/3699-code-returning-html-table-data-into-array. Once you have the data in the array, you then could search for how to write data to excel with php.

 

Hope that helps