Micro Focus QTP (UFT) Forums
RE: Webtable - GetCellData to LocalSheet - another question - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: RE: Webtable - GetCellData to LocalSheet - another question (/Thread-RE-Webtable-GetCellData-to-LocalSheet-another-question)



RE: Webtable - GetCellData to LocalSheet - another question - boludes - 01-24-2011

Hello all!! How are you??
I'm new here, I'm working with QTP, and I have a doubt

I'm trying to Get a value from a webtable and I don't know how can I put in my LocalSheet.

I used this to get the text from the table:
Code:
CellText = Browser("Application").Page("Application").WebTable("Code").GetCellData(2, 1)
MsgBox CellText
The MsgBox is correct, but I can't find the way to put this value into my LocalSheet
I'm trying to use
Code:
DataTable.LocalSheet.AddParameter but still not working


Thank you in advance


RE: Webtable - GetCellData to LocalSheet - sreekanth chilam - 01-25-2011

Hi Boludes,

You can go with any of the below ways:

Way1:
Code:
Datatable.LocalSheet.AddParameter "TableData",""
Datatable("TableData",dtlocalsheet)=CellText

Way2:
Code:
Datatable.LocalSheet.AddParameter "TableData",CellText



RE: Webtable - GetCellData to LocalSheet - another question - boludes - 01-25-2011

Thank you very much sreekanth chilam !
I will try these ways ass soon as I can

Thanks.


RE: RE: Webtable - GetCellData to LocalSheet - another question - boludes - 01-25-2011

Sorry for re-post Sad

Very well !! This new code works almost perfectly, becouse, How can I set the values in the rows, not in the columns??

Thanks in advance !