Ranorex connection with Teradata Server

Ask general questions here.
ajith3201
Posts: 5
Joined: Thu May 18, 2017 2:58 pm

Ranorex connection with Teradata Server

Post by ajith3201 » Mon Apr 16, 2018 4:38 pm

Hi
I am able to connect Teradata Server with Ranorex and read the output of query but i am not able to export that output table to an excel sheet. Please help...

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

Re: Ranorex connection with Teradata Server

Post by odklizec » Tue Apr 17, 2018 8:08 am

Hi,

I'm afraid, there is not enough details about your problem. Is there a UI with which should Ranorex interact? Could you please post an example of Teradata Server output, you are expecting to export to Excel table? Ideally, post a Ranorex snapshot (NOT screenshot!) of the output table (if there is such a thing like table).

Generally speaking, there is no built-in tool in Ranorex to export data to Excel. For this, you will have to use an open source/commercial library/code, with which you can store data to Excel file (e.g. Microsoft.Office.Interop.Excel, EPPlus, etc...). If you can live with CSV output, which can be opened in Excel, you can use Ranorex-own CSV writing methods.

Basic Table manipulation code (in Ranorex) is described here:
https://www.ranorex.com/help/latest/cod ... WholeTable
Excel writing:
https://www.ranorex.com/forum/writing-e ... t1605.html
https://www.ranorex.com/forum/write-dat ... tml#p44386
CSV writing:
https://www.ranorex.com/forum/writing-i ... tor#p34657
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