Convert text to excel

Help Activities
1

Hi all,
I have a text file and I need to conver it to excel.

My text file consists of the below data
Name|Date|Time|Sol ID|Remarks
XYZ|21-05-2022|16:24:20|7654|Success

So in my excel I want header as Name Date Time Sol ID and Remarks

And under name xyz should display and under date 21-05-2022 should come and under time 16:24:20 must come and under Sol ID column 7654 should come and under remarks success must display.

Please help me how to go with it

2

Hi @hanviprebday

Have you tried woith Generate data table activity?

image
image886×630 21.2 KB

3

Hi @hanviprebday

Read text file
Use Generate Datatable from text activity

image
image1095×516 25.1 KB

4

Hi @supriya117 my generate data table looks different

IMG_20231016_103047
IMG_20231016_1030471920×866 67.3 KB

5

Hi @hanviprebday

Copy this text and paste in sample input

Name|Date|Time|Sol ID|Remarks
XYZ|21-05-2022|16:24:20|7654|Success

and then click on preview

6

@hanviprebday

Copt and paste the text in the sample output wizard and click preview to check the data is converting to datatable correctly or not.

7

Hii @hanviprebday

Try this workflow

  1. Read Text File

    • Output: textFromFile

  2. Create Data Table (DT)

  3. Assign

    • TypeArgument: System.String
    • Value: textFromFile.Split(Environment.NewLine.ToCharArray, StringSplitOptions.RemoveEmptyEntries)
    • Output: lines

  4. For Each

    • TypeArgument: System.String
    • Values: lines

    Assign
    - TypeArgument: System.String
    - Value: item.Split(","c)
    - Output: columns

    Add Data Row
    - DataTable: dt
    - DataRow: columns

  5. Write Range

    • DataTable: dt

Cheers…!

8

Hello @hanviprebday
Kindly refer to the Xaml file, it will heps you.
Forum_Text_to_Excel.zip (148.5 KB)

image
image880×628 28.2 KB

image
image1124×794 17.9 KB

9

But my generate data table doesn’t have the format option

10

@hanviprebday

Upgrade or Downgrade UiPath.System.Activities package

11

@hanviprebday

It’s just the variations of system activities package version. What you have placed is correct. Check with that settings. If the output varies then we can change the properties.

12

Ok I am using 20.10.4 which version should I use

13

@hanviprebday

Try with latest version

14

Ok thank you all, it’s working for me

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.