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.
Excel data; I want to read data and iterate in code NOT DDT
Re: Excel data; I want to read data and iterate in code NOT DDT
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
Hi,
Just in case you still want to use Ranorex-own methods, you can use ExcelDataConnector to read data from excel.
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 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
Re: Excel data; I want to read data and iterate in code NOT DDT
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
Sure, check for example this post:
how-to-access-multiple-excel-files-from ... tml#p23324
how-to-access-multiple-excel-files-from ... tml#p23324
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
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