Split "," and put into each column

[Lau_Wei_Ting]

Hi,
I have this

and wish to display with this pattern in excel file

How should I do that?
Thanks a lot if anyone can help me.

[balupad14 (Balamurugan)]

Hi @Lau_Wei_Ting,

Here is the screen design :

Sample : Lau_Wei_Ting.zip (17.6 KB)

Regards
Balamurugan.S

[Palaniyappan (Palaniyappan P)]

Hi
If this is assigned to a string variable named str_input
—then use excel application scope and pass the file path as input and that file don’t need have any records
—inside the scope use read range activity and get the output with a variable of type datatable named dt and disable ADD HEADERS property
—now use a assign activity like this
arr_str = Split(str_input,”,”)
Where arr_str is a variable of type array of string
—now use a add Datarow activity and pass the input as arr_str to ARRAYROW property and mention the datatable as dt
—now use a Write range activity and pass the variable dt as input without add headers property enabled

Cheers @Lau_Wei_Ting

[kadiravan_kalidoss (Kadiravan K)]

WriteColumnsExcel.xaml (8.8 KB)

Thanks!

[Lau_Wei_Ting]

Hi, I have encounter another problem of object disallow implicit conversion.
Here is my workflow and data
Book1.xlsx
testing.xaml

Can anyone help me with this? I appreciate it a lot!

[mukeshkala]

Hi @Lau_Wei_Ting

1. How About saving the .xlsx as .csv File.
2. Reading the Csv with Comma Separator.

Other Approach can be using Excel UI Automation

Thanks,
Mukesh