Importing Excel into UFT always goes to GlobalSheet
| ♥ 0 |
Using the below code I am trying to import an Excel spreadsheet into UFT datatable. My Excel spreadsheet only has one worksheet called "TestData". Only thing is, instead of importing into the DataTable sheet called "TestData", it always goes into the GlobalSheet instead of my TestData sheet. How can I fix this? Datatable.Importsheet (TestDataFile),"TestData", 1
Marked as spam
|
Posted by |
Private answer
DataTable and Excel sheet indexes begin with 1, so if you use 1 as the index of the DataTable sheet, as your code shows, then it will always import into the GlobalSheet. The GlobalSheet is always present in a UFT GUI test and will always be index of 1. To change the sheet that the imported data goes into, either use the sheet name or a different index. You can find this and other related information in the [UFT Help Center][1]. [1]: https://admhelp.microfocus.com/uft/en/14.03/UFT_Help/Subsystems/FunctionReference/Subsystems/OMRHelp/OMRHelp.htm#cshid=OV_Supp_Util/Parameterization_DataTable.htm#ImportSheet Marked as spam
 Posted by Michaeldx (Questions: 17, Answers: 807) Answered on July 24, 2018 8:35 pm
|