Tuesday, October 19, 2010

RAWVALUE QTP

QTP Datatable.RawValue

While you read from excel, cells which contain formula's like =Today(), =Date()
may not reflect the same text when you retreive them.

Workarounds
1. So you might change in the cells in Excel as follows:
=Text(TODAY())

2. use
vCellValue=Datatable.GetSheet("sheetname").getParameter("ColumnName").RAWVALUE
instead of 
vCellValue=Datatable.GetSheet("sheetname").getParameter("ColumnName").VALUE

No comments:

Post a Comment