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...
Ranorex connection with Teradata Server
Re: Ranorex connection with Teradata Server
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
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 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