[wtr-general] How to determine last used row in Excel sheet
Hi all, I need to find out the last used row number in my excel work sheet. I am able to find out the number of rows in a used area using this code snipped worksheet = workbookObject.WorkSheets(Results Sheet) worksheet.Select usedArea=worksheet.usedRange puts usedArea.Rows.Count Please any one help me to find out the last used row number. Cheers Siva Phaneendra Krapa --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: How to determine last used row in Excel sheet
If I understood your question correctly, you are getting data from the excel spreadsheet in a for loop and you can print the last row used using the iteration value. On Thu, May 7, 2009 at 3:27 AM, sHiVa krapa.ph...@gmail.com wrote: Hi all, I need to find out the last used row number in my excel work sheet. I am able to find out the number of rows in a used area using this code snipped worksheet = workbookObject.WorkSheets(Results Sheet) worksheet.Select usedArea=worksheet.usedRange puts usedArea.Rows.Count Please any one help me to find out the last used row number. Cheers Siva Phaneendra Krapa --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: How to determine last used row in Excel sheet
Hi Anu, Thanks for your suggestion. As u said i can navigate to the last row in the used range of excel and print the data. My question is the used range may start from any cell like Range(D5:H10). I would like to determine the H10 (Where 10 is the last used row number) value in the range. any way i got the solution for my query. Here is the statement useful usedAreaaddress=worksheet.UsedRange.ActiveRange.adress That will return the address of Used range in an excel sheet Regards Siva Phaneendra krapa --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Watir on VISTA
I am running Watir on Vista: Ruby Version: ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] Watir Version: 1.6.2 Rgds, Anu On Thu, May 7, 2009 at 11:41 AM, Super Kevy kpe...@scholarshipamerica.orgwrote: I did a search and the group threads says Watir runs on Vista. Just need a minor confirm and what version(s) of ruby and watir are the minimums for the Vista OS WATIR rocks!!! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] How to work with DevEx Menu Items?
Any one worked on DevEx Menu Items..? I have Menu Items like System on top of my application in the browser, when I click on it I will get three dropdown child menu items. Does any one know how to work with them. I am able to click on by using following code. ie.span(:text, 'System').click But how to actually know what is there in the drop down menu and click the items to navigate to another page. Any help with this will be greatly appreaciated. === Here is HTML code I could see...this is not much help. td id=ctl00_menuMain_DXI0_T class=dxmMenuItemWithPopOutImage onclick=aspxMIClick(event, 'ctl00_menuMain', '0') style=height: 17px;cursor:hand;text-align:Left;padding-top:2px;padding-bottom: 2px;border-right-width:0px!important;padding-right:0px! important;span style=cursor:hand;System/span/tdtd id=ctl00_menuMain_DXI0_P class=dxmMenuItemWithPopOutImage onclick=aspxMIClick(event, 'ctl00_menuMain', '0') style=cursor:hand;text-align:Left;padding-top:2px;padding-bottom: 2px;padding-left:4px!important;border-left-width:0px!important;img id=ctl00_menuMain_DXI0_PImg src=/Tele-Works/WebResource.axd? d=OhLI4QJM0_rJxt56Dk3574oNUz- PucLOmmCLlh_9Yc_rpypz0qHo_zMCYAsmU3OkX5G2kenq3iY5zGcgREPef88apqlpiRLq_fMtsfDekWFR3GSoupXlZQza8o5J59zz0amp;t=63376171408225 alt= title= style=border-width:0px; //td = Thank you very much. Satish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Weird timing behavior when using assert(object.exists?) when widgets exist.
When I open a page that has widgets it hangs on assert(object.exists?) I've tried. Added a long wait to make sure the page is fully loaded. Which did nothing. I've minimized the page - which worked When it's running, and it starts to hang, I open another browser/or click different page ot tab and it no longer hangs. I've put timers in and realized it freezes on the follow: assert(object_id.exists?) #Any object if button_id == nil I opened in Firefox and the page doesn't display errors when using Firebug. I'm actually testing using IE 7.0. Has anyone run into this or does anyone have a suggestions? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Weird timing behavior when using assert(object.exists?) when widgets exist.
What's a widget? My search on Wikipedia turns up this: http://en.wikipedia.org/wiki/Widget. I also have no clue as to what button_id or object_id are - though I can take guess, but it's custom code. Simplify and post some real live code for your stuff and the html for the app. Charley Baker blog: http://blog.charleybaker.org/ Lead Developer, Watir, http://wtr.rubyforge.org QA Architect, Gap Inc Direct On Thu, May 7, 2009 at 1:53 PM, Moochie dduph...@redbrickhealth.com wrote: When I open a page that has widgets it hangs on assert(object.exists?) I've tried. Added a long wait to make sure the page is fully loaded. Which did nothing. I've minimized the page - which worked When it's running, and it starts to hang, I open another browser/or click different page ot tab and it no longer hangs. I've put timers in and realized it freezes on the follow: assert(object_id.exists?) #Any object if button_id == nil I opened in Firefox and the page doesn't display errors when using Firebug. I'm actually testing using IE 7.0. Has anyone run into this or does anyone have a suggestions? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Re: Weird timing behavior when using assert(object.exists?) when widgets exist.
Have you been to igoogle? Those information boxes are widgets. The html is basically Div(:id,widget_blah), but when a page open they use ajax to load the information on the widgets separately from the rest of the page. As for button_id is the a variable I use for a button button_id = $ie.button(:text,blah) I think I might have figured out a solution. Thanks for the reply From: watir-general@googlegroups.com [mailto:watir-gene...@googlegroups.com] On Behalf Of Charley Baker Sent: Thursday, May 07, 2009 3:17 PM To: watir-general@googlegroups.com Subject: [wtr-general] Re: Weird timing behavior when using assert(object.exists?) when widgets exist. What's a widget? My search on Wikipedia turns up this: http://en.wikipedia.org/wiki/Widget. I also have no clue as to what button_id or object_id are - though I can take guess, but it's custom code. Simplify and post some real live code for your stuff and the html for the app. Charley Baker blog: http://blog.charleybaker.org/ Lead Developer, Watir, http://wtr.rubyforge.org QA Architect, Gap Inc Direct On Thu, May 7, 2009 at 1:53 PM, Moochie dduph...@redbrickhealth.com wrote: When I open a page that has widgets it hangs on assert(object.exists?) I've tried. Added a long wait to make sure the page is fully loaded. Which did nothing. I've minimized the page - which worked When it's running, and it starts to hang, I open another browser/or click different page ot tab and it no longer hangs. I've put timers in and realized it freezes on the follow: assert(object_id.exists?) #Any object if button_id == nil I opened in Firefox and the page doesn't display errors when using Firebug. I'm actually testing using IE 7.0. Has anyone run into this or does anyone have a suggestions? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
[wtr-general] Unable to attach to a page on makemytrip
Hi all, i am unable to attach on the results page of www.makemytrip.com. Whenever I search for a particular flight and want to sort the results, watir apparently gets hung on the results page... Please let me know why this is so... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Watir General group. To post to this group, send email to watir-general@googlegroups.com Before posting, please read the following guidelines: http://wiki.openqa.org/display/WTR/Support To unsubscribe from this group, send email to watir-general-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/watir-general -~--~~~~--~~--~--~---
