How to read/write data from/to excel?

Best practices, code snippets for common functionality, examples, and guidelines.
adipau
Posts: 1
Joined: Wed Jan 17, 2018 10:57 am

How to read/write data from/to excel?

Post by adipau » Wed Jan 17, 2018 11:13 am

Hi all :)
i tried to figure out that issue and found that there are some plug-ins that need to be installed in order to work with excel tables.
that was a correspondence which regarded to Ranorex 3.x version.
does anyone knows how to interact with excel tables?
do i need to download any plug-ins or is it already built-in ability?
thanks in advance,
adi

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

Re: How to read/write data from/to excel?

Post by odklizec » Thu Jan 18, 2018 12:47 pm

Hi,

As for reading data from Excel files, you can use Ranorex data connector methods (Excel is required on target machine).

As for writing Excel files, probably the easiest way is to use MS Interop.Excel methods. Check for example this post, discussing Excel reading/writing.
write-data-to-file-in-data-driven-tests-t11036.html
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