How to Convert String to DataTable and write into excel

I have input Data —>inputstring =" Red Blue Orange Black "
and write into Excel Columns like
Index color
0 Red
1 Blue
2 Orange
3 Black
can anyone help this ?

@Anand_Designer

  1. Split the string with " " (Black space)
  2. Use for each row activity
  3. use write cell activity to write it into an excel sheet

Best Regards,
Vrushali

1 Like

@Anand_Designer

  1. Use Generate data table activity
  2. Pass the string variable as input
  3. Use " " in your case as a column separator

2 Likes

Check this below workflow, @Anand_Designer
Uipath_BuildDataTable.xaml (7.6 KB)
Hope this may help you :slight_smile:

1 Like

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