How to get the visible data from a particular cell in SwfTable object

Hi

When I was using GetCellData method, iam retrieving the data like “1617.0792315” from a cell.

But the displayed(visible) value is rounded to 2 decimals and showing as “1617.08”. To do some validations at any cost i need to retrieve only the visible value from all cells in a table.

To achieve this, which method i supposed to use in QTP?

Any help is highly appreciated.

Regards

Lakshmi

Lakshmi,

You can use either the GetCellProperty or GetNAProperty methods to get the Text of the cell.  For example, both of the following could be used:

msgbox SwfWindow("WinEditors Within WinGrid").SwfTable("ultraGrid1").GetCellProperty("1","0;Item","Text")

msgbox SwfWindow("WinEditors Within WinGrid").SwfTable("ultraGrid1").GetCellProperty("1","0;Item","Text")

Note that the second parameter for GetCellProperty is the column and requires the band before the column, this is why "0;" is passed in as part of the column string.

For GetNAProperty, you may want the to read my post on Where to get a list of all properties I can view using GetNAProperty?

Let me know if you have any questions with this matter

Alan

Hi Alan

GetCellProperty is working as per my requirement. Before posting the query I tried with GetCellProperty("1","0;Item","Value"). But it is also getting the complete hidden value. that's why posted.

Thanks alot for the help.

Regards

Lakshmi

Use dotnet spy and try to find where the required data is stored and script it like

For k= 0 to …….SwfTable("ultraGrid1").Object.Datasource.Column.count-1

If …….SwfTable("ultraGrid1").Object.Datasource.Column.Item(k).ColumnName="0;Item' Then

 ColumnIndex=k

End If

obj=…….SwfTable("ultraGrid1").Object.Datasource.Row(RowNo).Array

required text=obj(ColumnIndex)

 

 

Let me know if it doesnot work.

Fawaz