Hi Everybody
Well. I need some help. My requirement is to read information from a website directly and store it into an Excel sheet. Please help me out. I am stuck with this problem from four days without any solution.
Thanks in advance
Harish
Hi Everybody
Well. I need some help. My requirement is to read information from a website directly and store it into an Excel sheet. Please help me out. I am stuck with this problem from four days without any solution.
Thanks in advance
Harish
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Bechir BejaouiPosted Feb 12, 2009, 5:09 AM
Harish Kumar Meruva KodandaPosted Feb 11, 2009, 5:53 AM
Hi
Well. I need not rip all the data from the web page. The situation is like this. Just imagine a search site. You are searching something and the result set has to be ripped off and and then that data is to be seggregated and stored in the excel file. What I have persued is like, i have done all the seggregation basing on the css class names. Things i could not achieve are
1. I have to get the result set directly. Not like 10 results in one result set and another 10 results in the next page. It will be easy if we get all the result sets in a single shot.
2. Store the seggregated data into excel sheet.
Thanks in advance
Harish
Bechir BejaouiPosted Feb 10, 2009, 11:20 AM
Check whether the targeted website has an rss feed to get a particular info then add this info to an xml structured file, afterward Excel it self provides tools to deal with xml traffic.
http://office.microsoft.com/en-us/excel/HP010423511033.aspx
Web scrapping is used for entirely different purposes
You can create an excel addin that reads a rss feed and store it within an excel instance