Page 1 of 1

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

Posted: Mon Dec 06, 2021 10:40 am
by navneet
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.

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

Posted: Mon Dec 06, 2021 1:07 pm
by odklizec
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?

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

Posted: Mon Dec 06, 2021 1:39 pm
by navneet
NALAnalysis.txt
Sure. Here is the text file attached in which values are present.
Can you please give any inputs.