Excel format for UFT 12.52
We upgraded QTP from 12 to 12.52. All of our Excel datasheets were .xls format (Excel 2007 or 2003). But started to see problem when used operation such as DataTable.AddParameter comman. It started to show rowcount very large number. Should we be using only .xlsx format?
Hope you are doing well.
By analyzing Table control/pane:
It visually looks like a Microsoft Excel's Workbook (group of sheets)
File extension used is XLS (*), just as Microsoft Excel's
GUI DataTable feature is a third-party component. For more information, see Document ID KM781683 - Is the GUI DataTable control based on Microsoft Excel?
Hope you will find well this information.
Customer Support Engineer
If you find thst aat this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the pond show your appreciation.
This is a known issue related to formatting in Excel.
You can remove the formatting in the excel file. Check this post. Fix Format issues
Alternately you can use a .xlsx file instead of .xls.