How can convert Text file to Excel file

Learning Hub Academy Feedback
, ,
1

i download Text file from FTP and i want ot convert to Excel file to get data yesterday data from that text but my issue i recive the text as shown below

text1
text11741×883 148 KB

and from this data i want to copy yesterday data like this

text2
text21905×974 185 KB

any one have solution for this or if i can convert this to Excel i think it will be easy to get the data

1 Like
2

hi @Mohamed_Abbas

use UiPathTeam.FileConverter.Activities for converting the format of any file. you will have to install from manage package from uistudio and also find more information on below link.

Hope this will resolve your problem…happy learning :slight_smile:

2 Likes
3

@byeole.hr Hi, This package doesn’t contains activity for Converting from text file to excel.

Do you know any another package or activity for Converting from text file to excel.

4

Hi @Manjuts90

As of there is no activity to convert text to excel

1 Like
5

hi @Manjuts90
U can read data from text file and write range in excel

6

@byeole.hr hi, data from text file will be in string format, as for as I know we can’t use string write range activity.

1 Like
7

Hi @Manjuts90
Use Extract Structured data activity for this input is string and output is data table

1 Like
8

hi @Manjuts90
We have below converter available
Doc to Docx
Docx to Doc
Word to PDF
Xlx to Xlsx
Xlsx to Xls

These are the formats available in the package that I am currently using :slight_smile:

1 Like
9

@byeole.hr thanks

10

i solved this issue like i download the text file From FTP and saved AS csv then from csv converter to xlsx

and working with me fine as i want

11

@Mohamed_Abbas
Hi, Can you please send your sample file shows converting from csv to excel

Thanks.

1 Like
12

Total Doc Converter is a professional solution for converting documents: ( Word, Doc, DocX, DocM, RTF, RVF, or TXT files) into PDF, DOCX, XLS, JPEG, PNG, TIFF, HTML, XHTML, RTF, DOC, TXT in batch. Featuring an intuitive interface design, new users will find that it’s easy to set-up and run conversion projects. For advanced users, the Total Doc Converter can be run via [command line] as well. You can visit site by typing coolutils in google search go to category Total Doc Converter on left bar menu.