Page 1 of 1

Excel data; I want to read data and iterate in code NOT DDT

Posted: Mon Jun 18, 2018 3:52 pm
by sstowe
I want to write a user code module open a sheet from a multisheet workbook to iterate through it. I am rusty with Ranorex user code modules and the System.Data namespace. Can anyone point me to a reference on working with System.Data (Excel specific and C# preferred but I will take what I can get).

Thank you.

Re: Excel data; I want to read data and iterate in code NOT DDT

Posted: Mon Jun 18, 2018 5:04 pm
by sstowe
Nevermind. This is not really a Ranorex question but a System.Data question. Thanks.

Re: Excel data; I want to read data and iterate in code NOT DDT

Posted: Tue Jun 19, 2018 7:27 am
by odklizec
Hi,

Just in case you still want to use Ranorex-own methods, you can use ExcelDataConnector to read data from excel.

Re: Excel data; I want to read data and iterate in code NOT DDT

Posted: Tue Jun 19, 2018 2:18 pm
by sstowe
I could not find an example of this. Do you have a reference you could share? Thank you.

Re: Excel data; I want to read data and iterate in code NOT DDT

Posted: Tue Jun 19, 2018 2:29 pm
by odklizec