How to start automation

Help Activities
1

Hi,
I want to ask on how to start my automation.
Im doing my report on daily basis. So i will start by opening an excel file where it has already a header with data yesterday. What i do is i will open a text file, so it will replace a new data . How i want to automate it using uipath

1 Like
2

Hi @Nur_Amin

Please use excel activities to read and write to excel…and then write text file/read text file for your text activities. Excel is generally read into a datatable which is like a table format

Cheers

3

Can you give me example? Im new to this

4

Hi @Nur_Amin

Please go theough this

or alternately through the official site

Cheers

5

I dont get it with the video

6

Hi @Nur_Amin

Did you do your basic training on academy? I would suggest that because you need a basic understanding of activities and how to use…

With current info i can see that you need to read excel and text but what you want to do with it is something only you know…giving more details on it will give a chance to point you to exact activity what you need to use

Cheers

7

What the meaning of this? I already do the read file

image
image1920Ă—2560 861 KB

8

Hi @Nur_Amin

What activity are you using?

Cheers

9

Read text file

10

Hi @Nur_Amin

Thats is a warning.not an error…you would have given a string as path…assign string to a variable and pass the variable here…then it would not show the warning

Cheers

11

I think im a bit lost. What i need to put in this generate data table?

image
image1920Ă—2560 716 KB

12

I start with read text file. Is it correct i put the text file that i want to convert to the excel? Then what should i do next?

image
image1920Ă—2560 702 KB

1 Like
13

Hi @Nur_Amin

Say you have data in string like this

1,2,3
A,b,c

Then if you pass this string to genwrate datatable and give row separator as new line character and column separator as comma… this string will be converted to a table with twp rows and 3 columns

Then use write range to write this data to a excel

Cheers

14

May i ask your kindness to teach me step by step?

15

Hi @Nur_Amin

I can but…can you put exactly what you need to do…i ll give you steps…you can try…

If you want to read textfile…what you did is correct…

Now from that what data you need to paste in excel?? And how should it look

Once you have those then accordingly steps can be given

Cheers

16

I will explain on how i do it manually

  1. I will open one excel file, then by using that file, i will open a text file.after using this (u can refer to the image), i will proceed to data cleaning where i will delete all immediately things that i dont need
    image
    image1920Ă—2560 1.09 MB
17

Im a bit lost on how to start those step using uipath

18

Hi @Nur_Amin

This is clear…so follow these steps.

  1. Read text file(already you did it)
    It will give you a string as output…
  2. Generate datatable…now in your excel in the wizard you will select column is separated by dilimiter and all right ?, the same way here select the column separator and row separator…when we say separator it means the delimiter.
    This will give you a datatable as output and input is string from first step
  3. If you want to delete any columns…use delete data column…either give column number or name…numbers for column starts from 0 not 1.so first column number is 0
    This will give you datatable with removed columns
    4.if you want to remove any rows …then use filter datatable…and giv eyour conditions like column c contains “test” then if will filter all rows which have text in it in column c. Here column c is the column name…
  4. Use write range and write data to excel.

Done

Cheers

1 Like
19

Hello @Nur_Amin

If you want to convert text to datatable you can use the below 2 approaches as mentioned in the video.

Activity:

  • Generate datatable
  • Text to column activity
20

For your step 3 &4, where do i need to edit?