Hi Everyone, i’m facing a issue in excel, i’m getting some data in excel in that data i have to split the data based on special character and i need to write that in another excel but here i’m able to split data but i’m not able to write it in another excel properly. can anyone help me how to solve this.
I’m attaching XAML files also please check
BOT ALLOCATION.xlsx (26.9 KB) CERS.xaml (13.0 KB) New.xlsx (10.0 KB) Spliting_Names.xaml (11.7 KB)
Note : CERS is my main file and Spliting_Names i invoked in CERS Xaml
2: Bot allocationis my data excel and in NEW excel i need to write splitted data