[wtr-general] How to determine last used row in Excel sheet

2009-05-07 Thread sHiVa
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

[wtr-general] Re: How to determine last used row in Excel sheet

2009-05-07 Thread Anu Gangavaram
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

[wtr-general] Re: How to determine last used row in Excel sheet

2009-05-07 Thread sHiVa
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

[wtr-general] Re: Watir on VISTA

2009-05-07 Thread Anu Gangavaram
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

[wtr-general] How to work with DevEx Menu Items?

2009-05-07 Thread satish
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

[wtr-general] Weird timing behavior when using assert(object.exists?) when widgets exist.

2009-05-07 Thread Moochie
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

[wtr-general] Re: Weird timing behavior when using assert(object.exists?) when widgets exist.

2009-05-07 Thread Charley Baker
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

[wtr-general] Re: Weird timing behavior when using assert(object.exists?) when widgets exist.

2009-05-07 Thread Darin Duphorn
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 =

[wtr-general] Unable to attach to a page on makemytrip

2009-05-07 Thread Isabel
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