Very basic question.
I have a excel dataconnection created.
1 aaa
2 bbb
3 ccc
How do I read with C# code e.g. row 3 column 2 data [ccc] ?
Or do I need to create:
ExcelDataConnector and use that to read data?
Read data from database
Re: Read data from database
And one more question:
Now that I can read the data from excel file (how-to-access-multiple-excel-files-from-usercode-module-t5553.html)...
how can I input data to excel?
Can I use somehow excelConnector.StoreData() method and how to do it?
Now that I can read the data from excel file (how-to-access-multiple-excel-files-from-usercode-module-t5553.html)...
how can I input data to excel?
Can I use somehow excelConnector.StoreData() method and how to do it?
Re: Read data from database
Hi,
I'm afraid, there is currently no way to add data to excel via Ranorex data connector. You will have to implement your own Excel writing, based of 3rd party excel components of MS methods.
In Ranorex, it's possible to save data with CSV data connector. This is why it's much better to use CSV, instead of excel. Additionally, Ranorex is also much faster when working with CSV files, it's possible to directly edit CSV files in data connector dialog and it's possible to compare CSV files via any text comparison tool (or in source control).
I'm afraid, there is currently no way to add data to excel via Ranorex data connector. You will have to implement your own Excel writing, based of 3rd party excel components of MS methods.
In Ranorex, it's possible to save data with CSV data connector. This is why it's much better to use CSV, instead of excel. Additionally, Ranorex is also much faster when working with CSV files, it's possible to directly edit CSV files in data connector dialog and it's possible to compare CSV files via any text comparison tool (or in source control).
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: Read data from database
Hi,
thank you for your answer. I can well manage with CSV.
What I need is to check while running cases how many options some list have (A,B,C...) and then run the cases with that data with other list.
e.g.
A: 1-2-3
B: 1-2-3
C: 1-2-3
...
Is it possible to save this data (A,B,C..) and use it as data source / bound variable ?
Sorry again not been able to explain my problem clearly (as a non-programmer )
thank you for your answer. I can well manage with CSV.
What I need is to check while running cases how many options some list have (A,B,C...) and then run the cases with that data with other list.
e.g.
A: 1-2-3
B: 1-2-3
C: 1-2-3
...
Is it possible to save this data (A,B,C..) and use it as data source / bound variable ?
Sorry again not been able to explain my problem clearly (as a non-programmer )
Re: Read data from database
Hello SanMan,
I am not sure that writing into a CSV file during runtime is actually necessary in this case. Please describe your use case in more detail and probably someone will come up with a simpler solution.
Regards,
McTurtle
I am not sure that writing into a CSV file during runtime is actually necessary in this case. Please describe your use case in more detail and probably someone will come up with a simpler solution.
Regards,
McTurtle
Re: Read data from database
Hi McTurtle,
There must be something wrong with the link: "The page you requested cannot be found.
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable"
But no problem; I did solve the problem without writing during runtime
BR,
SanMan
There must be something wrong with the link: "The page you requested cannot be found.
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable"
But no problem; I did solve the problem without writing during runtime
BR,
SanMan
Re: Read data from database
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