I have a downloaded copy of a website that consists of a series of three-column tables. The site's URL can be found in the attached [url removed, login to view] file. I need the data in these tables parsed into spreadsheet format.
Each row represents a place. The three columns are ID (first column), Name (second column), and Center (third column). Clicking on a place's ID number or name takes you to a new table that contains the set of places subordinate to the one you clicked. You can then click on each of those places to see their subordinates, and so on.
My goal is to create a spreadsheet that contains the data from all of these tables. I also need a fourth column in the spreadsheet for Parent ID -- that will be the ID number of the place from the level above (the one you'd click to get to it). For example, starting on the URL in the [url removed, login to view] file, if you click on the first entry (01000000000), the three places on the next page would each have a parent ID of 01000000000. You can see an example of what this should look like in the attached sample.xlsx.
So, what I need is a program to recursively browse through the folder where I've saved the HTML, and create the spreadsheet from the data. I prefer .NET or Java, but can work with whatever you prefer to use.
Please let me know if you have any questions. Thanks for bidding!
Hey, Girish here, I can do this for you. Thanks Relevant Skills and Experience 7+ year exp. in asp.net c# web development with data scrapping. Proposed Milestones $88 USD - html table to excel file
21 freelancers are bidding on average $143 for this job
HI Me as web developer and expert in extract data and save in different [url removed, login to view] you allow me then I can work for you. Relevant Skills and Experience PHP Proposed Milestones $105 USD - final
Hello, I am a good VB, VBA, C# developer. I think I can do your job with success in 3 days. Relevant Skills and Experience C#, VB, VBA Proposed Milestones $200 USD - Total
Hi 30 USD and lets get started 1 day job for me Relevant Skills and Experience Is simple scraping job Proposed Milestones $35 USD - at the end of the project
Extract data from HTML tables into an Excel spreadsheet Relevant Skills and Experience .NET, Excel, HTML, Java, Programming Proposed Milestones $30 USD - c