Ranorex Forum

Code: Select all

var currentTC = TestSuite.Current.GetTestContainer("TCName");
var Min = currentTC.DataRange.MinRange+2;
var Max = currentTC.DataRange.MaxRange+2;
currentTC.DataContext.SetRange(Min,Max);

Code: Select all

 public static void RecreateVoucherCodeFile(string testCaseName, string DataSourceName)
 { 
        //Step 1: Create a new csv file with identitcal path an name to overwrite the current csv
		//create CSV data connector
		string filepath = @"C:\\Ranorex\\VoucherCodes.csv";
		Ranorex.Core.Data.CsvDataConnector csvConnector = new Ranorex.Core.Data.CsvDataConnector(DataSourceName,filepath,true);			
		csvConnector.SeparatorChar = ',';
		Ranorex.Core.Data.ColumnCollection OPCSVTableColumns = new Ranorex.Core.Data.ColumnCollection();
		Ranorex.Core.Data.RowCollection OPCSVTableRows = new Ranorex.Core.Data.RowCollection(OPCSVTableColumns);
				
	//Step 2: Load the complet csv into an Array
		csvConnector.LoadData(out OPCSVTableColumns, out OPCSVTableRows);
				
		int codeArrayLength = OPCSVTableRows.Count;			
		string[] codeArray =new string[codeArrayLength+1];
		int i = 0;
		foreach(Ranorex.Core.Data.Row dataRow in OPCSVTableRows)
		{ 
			codeArray[i] = dataRow[0].ToString();
			Report.Info(codeArray[i]);
			i = i+1;
		}

	//Step 3: Save the Array as Columns in the file
		//Emty  OPCSVTableRows
		OPCSVTableRows.Clear();

		//Add all elements to new csvfile execpt the first element which contains the used Code
		for (int z = 1; z < codeArrayLength; z++)
		{
			if (!string.IsNullOrEmpty(codeArray[z]))
			{
				OPCSVTableRows.Add(new string[1]{codeArray[z]});
			}
		}
		
	//Step 4: Save the file 
		// save CSV connector to file
		csvConnector.StoreData(OPCSVTableColumns, OPCSVTableRows);
				
	//Step 5: Let the Testsuie reload the datasource
		var tc = (TestCaseNode) TestSuite.Current.GetTestContainer(testCaseName);
		var source = DataSources.Get(DataSourceName);
		tc.DataContext.Source=source;
		tc.DataContext.Source.Load();
        
        }