How to convert comma values & write the same in each row?

Help Studio
1

Hi Team

I have struggling to make an automation converts this comma separated values & write the same in each row - Eggs, Milk, Bread, Butter.

A simple text document lists "Eggs, Milk, Bread, Butter" under a menu bar with options for "File," "Edit," and "View." (Captioned by AI)
A simple text document lists "Eggs, Milk, Bread, Butter" under a menu bar with options for "File," "Edit," and "View." (Captioned by AI)568×192 2.22 KB

Expected output -

A spreadsheet listing grocery items under the column labeled "Values" includes eggs, milk, bread, and butter. (Captioned by AI)
A spreadsheet listing grocery items under the column labeled "Values" includes eggs, milk, bread, and butter. (Captioned by AI)573×314 4.29 KB

Please help me with the steps or activities required to make this.

Regards
Naman

2

Hi @Naman_Arora

Assign ---- itemsArray = inputString.Split(","c)

For Each activity (TypeArgument: String):

Inside the loop, use Write Cell:

Write Cell: “A” & (Array.IndexOf(itemsArray, item) + 2).ToString
Value: item.Trim()

Happy Automation.

3

Hi @Naman_Arora

=> Use Build DateTable to create the column names

The image shows a "Build Data Table" dialog box with a single column labeled "Items (String)" and options to add or remove rows, and buttons for "OK" and "Cancel." (Captioned by AI)
The image shows a "Build Data Table" dialog box with a single column labeled "Items (String)" and options to add or remove rows, and buttons for "OK" and "Cancel." (Captioned by AI)608×431 5.41 KB

=> Read the text file and store it in a variable say str_Text.
=> Use the below LINQ to convert it to datatable
dt = str_Text.Split(","c).Select(Function(item) dt.Rows.Add(item.Trim())).CopyToDataTable()
=> Use Write Range Workbook to write the data to excel.
image
image147×197 1.68 KB

Check the below workflow for better understanding:
Sequence10.xaml (10.6 KB)

Hope it helps!!

4

Hie @Naman_Arora here is the method create one array of string variable and pass the value use 1 for each inside for each use write cell and increament the cell with currentindex variable

The image depicts a workflow in UiPath Studio for assigning a list of strings to a variable and writing each string to separate cells in an Excel worksheet. (Captioned by AI)
The image depicts a workflow in UiPath Studio for assigning a list of strings to a variable and writing each string to separate cells in an Excel worksheet. (Captioned by AI)932×499 25.3 KB

The image shows a configuration for writing data to a specific cell in an Excel worksheet, with the cell determined by the expression "A"+(currentIndex+2).ToString. (Captioned by AI)
The image shows a configuration for writing data to a specific cell in an Excel worksheet, with the cell determined by the expression "A"+(currentIndex+2).ToString. (Captioned by AI)828×206 12 KB

Sequence1.xaml (9.2 KB)
am attaching zip file and screenshot

cheers