+- 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: Default.xls is not updated in QTP 11 (/Thread-Default-xls-is-not-updated-in-QTP-11)
Default.xls is not updated in QTP 11 - atanu - 07-10-2011
I am facing a problem in QTP11.
Suppose there is two reusable action where data are present in default.xls.
Now I make a new test as a integration script where the two reusable action are called as external action.
Now if i changed any data in default.xls of resuable action, it is not updated in the integration test.
Is there any settings in qtp11 to overcome this issue.
Thanks in Advance...
RE: Default.xls is not updated in QTP 11 - rajpes - 07-10-2011
Every test has its own default.xls
The script inside the external action corresponds to default.xls of external test !
But when you call it as an external action, while execution of that script,qtp will search for default.xls of calling test! so it can actually throw error if same column names are not used in "calling test's default.xls"
Instead of messing up with these default.xls of multiple tests, create an excel file outside both the test folders and inside your integration project.
Use that path of file in the reusable action's code.Now when you call it as external action also, it will always get/set data present in the single excel file in that path!
However i suspect your problem to be not able to update the original file due to not exporting the data and directly trying to change table cell values which are in effect only during the run session!
So make sure you are using Datatable.ExportSheet/Export method after making necessary updates.
RE: Default.xls is not updated in QTP 11 - atanu - 07-10-2011
Thanks for your quick reply and your suggestions.
Actually in QTP 9.2, there is no problem about this.Integration script's default.xls is updated after any change in corresponding reusable scripts default.xls data. But in QTP 11,the problem arises.
RE: Default.xls is not updated in QTP 11 - rajpes - 07-10-2011
ok,do check external action properties(in called test) >"External Action" tab >first option "use data stored with original action" is selected or not ,
By the way you wouldn't face any problem when you use import and export methods
RE: Default.xls is not updated in QTP 11 - atanu - 07-11-2011
Thanks, now it works.I want exactly the same.
Actually in QTP 11, when we change any data in reusuable script, data is not updated in integration script due to it is selected the second option "Use a local,editable copy".So, I select the first option and updated data is shown.
So, your suggestion helps me to fix this issue.
And again say thanks and in future, we will use import and export method.
RE: Default.xls is not updated in QTP 11 - rajpes - 07-11-2011
Glad to know it's working.