Excel Automation - Write cell Question

Help Studio
, ,
1

Hi

How Can I write cell the vehicle type as car & bike for vehicle name and continues the same for each row.

Regards
Naman
image (4)

2

Hi @Naman_Arora

Use the write cell activity in the excel activities and loop this activity in for each row activity.
Check the Auto increment option in write cell activity

image
image880×1184 51.5 KB

Hope it helps!!

3

Hi @Naman_Arora

image
image761×331 11 KB

Hope it helps!!

4

Yes but How the bot can filter out that for car names it should write cars & same case for bike.

Can you show an example with the help of screenshot ?

5

I want develop a bot in such that first it filter like car names & write vehicle type as car for those then it filters out bike names and write bike as vehicle type. I can keep the bike & car names same for each row.

6

@Naman_Arora

For that you have the specific data to note the item is car or bike.
Then the bot will read the specific data that you provided then filter it by using the If condition.

7

Hi @Naman_Arora

Use array or dictionary to store the values like:
arr_car = {“I20”,“Verna”}
arr_bike = {“Dominator”,“Bullet”}

Use if condition in inside for each loop:
arr_car.contains(CurrentRow(“Vehicle”)) then
write cell:CurrentRow(“Type”) = “Car”
else:
Write cell:CurrentRow(“Vehicle”) = “Bike”

Hope it helps.

8

Hi @Naman_Arora

Provide the input excel and required output excel.

regards

9

@Naman_Arora

Check this:
Main.xaml (20.3 KB)

10

Hi Tried this but doesn’t working for me

11

Hi @Naman_Arora

Please share the error that you are getting.