How do i get eh number of value in en excel file in specific column?

Question

Hi,&nbsp;I'm reading an excel file with few columns and want to select random value from specific column. and i have problem with 2 things:&nbsp;1. I&nbsp;want to select the column by its header or index&nbsp;2. Once i found the right header each column had different values and different number of values below, for those values i would like to select a random value. my question is how do i determine how many values i have for each column so i can use the Random(min, max) func to select a random value.&nbsp;My script:&nbsp;// Open Devices_ModelSetup.xlsx for readingoExcelApp.Workbooks.Open("C:\TestComplete Database\Devices_ModelSetup.xlsx");for(i = 1; i &lt;= 12; i++)if(SeriesValueFromUI == VarToString(oExcelApp.Cells(1, i)))NumberOfModels = oExcelApp.Cells.Rangefor(k = 1; VarToString(oExcelApp.Cells(k, i)) != "" ; k++)ModelValue = VarToInt(oExcelApp.Cells(Random(1, k), i))&nbsp;Thanks

tristaanogre · Answer

On one level, I understand the use of randomized input data for testing certain functionalities of an application under test... but when I'm doing test automation where I need to have predictable inputs generating predictable results, this is where randomization as a testing tool becomes a bit... cumbersome.
&nbsp;
To be honest, rather than randomizing the data, I'd do one of two things:
&nbsp;
1) Run loops to go through and check all sub printers for all printers to make sure they all work... nested for loops or while loops or a for loop in a while loop or something like that. &nbsp;Automation gives great benefit for executing a LOT of tests faster than executing them manually. &nbsp;So, rather than randomizing... just test them all.
2) Rather than selecting randomized data, come up with a respresentative subset. &nbsp;Think about the idea of boundary testing... test low end, high end, mid point, out of bounds low, out of bounds high, extreme high, extreme low, etc... &nbsp;not saying that those are the cases to use here, but I'm pretty sure that there is a subset of the printers and sub printers that can be used so that, rather than starting with ALL the data and then just randomizing something out of it, pick a few representative values and use them in the test case.
&nbsp;
&nbsp;
With either of these two, then you don't have to worry about picking a specific value out of a column... you just create your excel sheet for all the test cases you want to run and build a DDT loop around it and just exercise all the selected test cases. &nbsp;This then gives you predictability... I know that when I run the loop for my data set, the first test will have one set of printer/subprinter and I'll know what to expect, and the second time, and the third time... &nbsp;

marsha_r · Answer

What is it that you are trying to accomplish with this? &nbsp;Maybe we can find you an easier way to do it.

ov · Answer

Hi Marsha,&nbsp;I have few printers models, for each printer model i've created a row in an excel file, each printer model had sub-models but, each printer has a different number of sub-models.&nbsp;I want to randomly select a printer and then randomly &nbsp;select printer's sub-model, means i first need to get the number of sub-models under the printer i've selected and then select this value from a combobox.&nbsp;Thanks,&nbsp;OV

marsha_r · Answer

tristaanogre&nbsp;Would this be easier to do with a Table?

Forum Discussion

How do i get eh number of value in en excel file in specific column?

4 Replies

Related Content

How to get a specific value from a specific grid row, column using Python?

Verify Frozen columns in Excel

Convert time to number

Rename Test Case Number

CLICKING ON A HYPERLINK WHICH IS NUMBER IN THE TOTAL COLUMN, NUMBER KEEPS GETTING UPDATED EVERY TIME

Recent Discussions

Searching for mapped object took too much time msg

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License

Devops integration support

Including Error Handling

TestComplete14.72 is not recognizing WinUI-3 objects