TGWSE_GY Posted January 26, 2010 Share Posted January 26, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/189820-reading-external-html-table-on-remote-server-into-excel-spreadsheet/ Share on other sites More sharing options...
sasa Posted January 26, 2010 Share Posted January 26, 2010 yes Quote Link to comment https://forums.phpfreaks.com/topic/189820-reading-external-html-table-on-remote-server-into-excel-spreadsheet/#findComment-1001706 Share on other sites More sharing options...
TGWSE_GY Posted January 26, 2010 Author Share Posted January 26, 2010 What should I be researching to achieve this then? Quote Link to comment https://forums.phpfreaks.com/topic/189820-reading-external-html-table-on-remote-server-into-excel-spreadsheet/#findComment-1001841 Share on other sites More sharing options...
TGWSE_GY Posted January 26, 2010 Author Share Posted January 26, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/189820-reading-external-html-table-on-remote-server-into-excel-spreadsheet/#findComment-1001909 Share on other sites More sharing options...
MatthewJ Posted January 26, 2010 Share Posted January 26, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/189820-reading-external-html-table-on-remote-server-into-excel-spreadsheet/#findComment-1001923 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.