Contributions
Re: Incorrect Row count of Excel, if we delete few rows
hi Mughees Siddiqui, Yoour solution..display a single count. for n number of rows. if i uses row = 2 Driver = DDT.ExcelDriver (excel path ..) while (! Driver.EOF()) { //process datato read ..here i want to rea only added daata in the rows.if the file has 4 rows.. i want to read only 4 data. I wan tto read from second row. So i defiened row = 2 } Driver.Next(); // Goes to the next record row++; } But when few of the data row from excel get reoved, it still start to read the blank data. This is my problem. Any one has solution ?2.3KViews0likes0CommentsIncorrect Row count of Excel, if we delete few rows
I have used followign code to read row count from Excel. var app = Sys.OleObject("Excel.Application"); var book = app.Workbooks.Open(fileName); RowCount = app.ActiveSheet.UsedRange.Rows.Count It works first time, for the records added in Excel. Latter we removed few rows, then try to run the script here it still displayed old row count, even though we now have less row count. Any solution on this ?9.9KViews0likes6CommentsHow to compare Table values.
My Scenario is that I am entering a some values in Text box as Call Aliases.QBIS.ExpressionEditor.expPanel.ExpressionEditorForm.expressionEdit.TextBoxMaskBox.Keys("3.5") Actually I am multiplying this ( 3.5) with some cloumn values. Like I have Rate column which contain following values. Rate 2 3 4 6 In My application I am Multiplying this Rate column with fixed integer 3.5, by which my application creates New Calculated column as New Calculated column 7 10.5 14 17.5 Now I am dropping both column into a single Grid and Inserted a table check point on it. And want to verify if New alculated values are as per the calculation i.e. 7=2*3.5 10.5= 3*3.5 and so on. For this how to store a value entered in Text box(Aliases.QBIS.ExpressionEditor.expPanel.ExpressionEditorForm.expressionEdit.TextBoxMaskBox.Keys("3.5")) into a variable.13KViews0likes2CommentsRe: unable to Select Grid control items
Hi Helen, I found the ClickRowIndicator Method when double click in Keyword view. Previously i verified it in Object spy in which it does not display the ClickRowIndicator method. I chnaged it to ClickRowIndicator method. But still it does not select the required rows. Also How to use below method grid.ClickRowIndicator(1, skCtrl) ? I guess this is for Control Key which enable to select multiple selection. But in Keyword I didnt find skCtrl ?1.6KViews0likes0CommentsRe: unable to Select Grid control items
Sorry Helen, for incomplete information. When i played the script ( here it is Keyword Script) nothing happen when the script came at that certain point. Actually I am trying to select few row values from the Grid and then clicking on the 'Add Group' button. As i have Uncheck the' Stop on Error; it just wait for the next object to enable. Also As u mention of the Grid.ClickRowIndicator method, I checked it for my Grid and it does not displayed this method. Instead it displayed ClickCellXY method when I recorded the script. But when played It stuck at this point.1.6KViews0likes0Comments