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
Follow this blog to get updated on RESOLVING SOLVING WORKAROUNDS FOR tricky issues using automation.
Disclaimer: I am not responsible for any damage or loss or profit on using this blog posts.
Web UI Automation with Windows PowerShell
Web UI Automation with HP QTP
Web UI Automation with OATS
Web UI Automation with Selenium
Desktop UI Automation
Windows Applications Automation with QTP
qtp windows application automation
No comments:
Post a Comment