Page 1 of 1
Ranorex connection with Teradata Server
Posted: Mon Apr 16, 2018 4:38 pm
by ajith3201
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...
Re: Ranorex connection with Teradata Server
Posted: Tue Apr 17, 2018 8:08 am
by odklizec
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