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

Ask general questions here.
sstowe
Posts: 62
Joined: Thu May 31, 2018 2:26 pm

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

Post by sstowe » Mon Jun 18, 2018 3:52 pm

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.

sstowe
Posts: 62
Joined: Thu May 31, 2018 2:26 pm

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

Post by sstowe » Mon Jun 18, 2018 5:04 pm

Nevermind. This is not really a Ranorex question but a System.Data question. Thanks.

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 3930
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

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

Post by odklizec » Tue Jun 19, 2018 7:27 am

Hi,

Just in case you still want to use Ranorex-own methods, you can use ExcelDataConnector to read data from excel.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

sstowe
Posts: 62
Joined: Thu May 31, 2018 2:26 pm

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

Post by sstowe » Tue Jun 19, 2018 2:18 pm

I could not find an example of this. Do you have a reference you could share? Thank you.

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 3930
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

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

Post by odklizec » Tue Jun 19, 2018 2:29 pm

Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration