Ranorex connection with Teradata Server

[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...

[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