Thank you for your reply. After re-reading what I have written and thinking about what I what to achieve... I don't believe I want to extract the table data into excel. I would like to extract it to a .txt (notepad document). The purpose of extracting the data is to check it against it against what I have in my database :-). If I can get it into .txt file (notepad document) I have the know-how to clean it and import it into sql for validation. FYI the data in the table looks like this... <table border="1" cellpadding="2"><tr><th> Address </th><th> Council tax band </th><th> Annual council tax </th></tr> <tr><td> 2, STONELEIGH AVENUE, COVENTRY, CV5 6BZ </td><td align="center"> F </td><td align="center"> £2125 </td></tr> ....... The above row is repeated many time ...... </table> Then the table is closed. So to re-cap my situation. I can use Watir to navigate the browser to the page containing the html table but my problem is that I am unsure of how to extract the results (everything within the <table> tag - including the html) to a .txt file and then save that .txt file onto my computer. I would prefer to take smaller steps with using Watir. I am knew to it therefore I would just like to learn how to extract the table and save everything that I have extracted into a .txt file. I have seen a couple of examples online using hpricot. However most of the examples seem to miss off code detailing how the array (if that is the correct approach) is outputted into a .txt file. Could you help by demonstrating how to write a simple piece of code which will extract the html table ( and everything, including the <tr>, <td> and everything in between) to a .txt notepad file? Many thanks for your time. On Dec 2, 2:36 am, bis <[email protected]> wrote: > To me that sounds like a lot of extra work what happens once it is in an > excel? Why would putting it in an excel be better than asserting it all > within the test itself > > So I'll go ahead and ask some questions first. > Will it happen more than once validating the excel? > What sort of data is in the table? > Would you be comparing the data in the excel vs data in a data base? If yes, > why not let the test do it? > > Sent from my iPhone > > On Dec 1, 2011, at 4:43 PM, Mark Ballinger <[email protected]> wrote: > > > > > > > > > Hi I am a newbie to groups and to ruby, watir, watir-webdriver etc... > > > Basically all I would like to do is export a table from a web page > > which I have instructed the browser to find using Watir-webdriver. I > > just want to take the whole contents of the html table and place it > > into Excel for further analysis. > > > I have the got the following code to work: > > > require 'rubygems' > > require 'hpricot' > > require "watir-webdriver" > > url = "http://www.mycounciltax.org.uk/results? > > postcode=cv35+8au&search=Search" > > browser = Watir::Browser.new > > browser.goto url > > > All i would like to do now is save the table. How do save the html to > > a csv or .txt file into my C;\Temp folder? > > > Best Regards, > > > Mark > > > -- > > Before posting, please readhttp://watir.com/support. In short: search > > before you ask, be nice. > > > [email protected] > >http://groups.google.com/group/watir-general > > [email protected]
-- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. [email protected] http://groups.google.com/group/watir-general [email protected]
