Ranorex Forum

Dear All,

I have problem with object DataSources()

Is there a way to get each excel column value in a row with this function?

Now I can use below code to get row count and column count

/////
var getExcel = DataSources.Get("MyConnector");

int column_count = getExcel.Columns.Count;
int row_count = getExcel.Rows.Count;
/////

if i got column_count = 3

can someone help me to get those 3 column values in excel file?

thanks

Hello,

Please take a look at the example code below:

for (int row = 0; row<row_count;row++)
{
	Report.Info("========== Row: " + row);
	for (int column = 0; column<column_count; column++)
	{
		Report.Info("Column: " + column + " Value: " + getExcel.Rows[row].Values[column]);				
	}				
}

Regards,
Markus (T)