I have one txt file, and I want to get all the txt file data in the data table format, so how can I do it? I have tried with the help of the “Generate Data Table” activity but I did not get any specific solution, because the txt file has multiple columns with spaces like “Customer Name, Product Nam…

How to open txt file with Excel file?

Rahul_Unnikrishnan (Rahul Unnikrishnan) October 19, 2022, 11:39am 11

You can use Generate Datatable or Text to Column activity. Please check the below video.

Thanks

Topic		Replies	Views
How to open a txt file by excel with seperate column? Help datatable , excel , activities	6	2893	July 6, 2018
Read .txt notepad and write into excel Help	31	2421	August 8, 2019
How to convert txt file to excel file Activities excel , activities , question	11	2392	August 25, 2020
How to get data from text file to Excel file StudioX excel , uiautomation , activities , studiox , question	10	1158	February 8, 2023
How to Convert .txt file data to CSV /xlsx? Help studio	22	8410	June 19, 2019