+- 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: Excel or Array? (/Thread-Excel-or-Array)
Excel or Array? - csutter2002 - 02-19-2013
Good Day, I was wondering why one would want to use an excel spreadsheet to store your data in as opposed to just an array?
I am creating test cases and have used arrays to store my variables in. I was thinking about using an excel spreadsheet, but then wondered why I should -- any thoughts?
RE: Excel or Array? - supputuri - 02-19-2013
Hi csutter,
there is no hard and fast rule to follow the data in excel file. But by keeping advantages people are going with excel like
1) user friendly, even non-automation guys can update the test data
2) Easy of maintenance
3) can quickly migrate to db with very minimal effort
4) can get perfect dictionary and you the advantages of Dictionary compare to array
hope this will be helpful.
RE: Excel or Array? - csutter2002 - 02-19-2013
Hi Supputuri,
Thank-you for this answer. It makes sense to me. I appreciate your time.
What about if you are just checking fields on a page? Does it still make more sense to use excel?
csutter
RE: Excel or Array? - supputuri - 02-19-2013
What do you mean by checking fields?
Is it a data validation or fields validation or object status validations?
RE: Excel or Array? - csutter2002 - 02-19-2013
I am doing field checking as well as looking at the lists for the pages and making sure that the default data lists are still the same.
RE: Excel or Array? - basanth27 - 02-19-2013
If you are validating run time data then use arrays. For eg: You have value in field A and you expect the same to come up on Field B during runtime then use arrays for your validation.
If you have a static data which you need to validate against the run time data, then you will need the data stored somewhere which probably may need to be updated at a later stage. Hence, you may have to use any file system for your maintenance.
RE: Excel or Array? - csutter2002 - 02-19-2013
Thank-you both for your help.
I now have a direction to go in and have an idea of what to put into a spreadsheet and what to put in an array.Cheryl