How to convert text file into Excel file using Ranorex code module

Experiences, small talk, and other automation gossip.
navneet
Posts: 8
Joined: Tue Aug 03, 2021 12:50 pm

How to convert text file into Excel file using Ranorex code module

Post by navneet » Mon Dec 06, 2021 10:40 am

I have a text file with values stored in it.
I need to convert the text file into excel file using ranorex code module?
After the content/values is migrated to excel file, data values should be formatted in individual cells. Can someone help me.

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

Re: How to convert text file into Excel file using Ranorex code module

Post by odklizec » Mon Dec 06, 2021 1:07 pm

Hi,

Unfortunately, without seeing the text file and its structure, it's impossible to suggest something reliable. Also, there is no built-in solution in Ranorex that would convert the text file to excel file. You will either have to use a 3rd party library for this or simply read the content of text file and fill the individual cells in newly created Excel worksheet (using Key Sequence or Set Value action). Could you please share the text file?
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

navneet
Posts: 8
Joined: Tue Aug 03, 2021 12:50 pm

Re: How to convert text file into Excel file using Ranorex code module

Post by navneet » Mon Dec 06, 2021 1:39 pm

NALAnalysis.txt
Sure. Here is the text file attached in which values are present.
Can you please give any inputs.
You do not have the required permissions to view the files attached to this post.