Hi,
PFA,
i was splitted the attached string into individual character’s
i need to write each splitted value into excel sheet like this sample
How to write like this?
For all the values
Thanks in advance
Hi,
PFA,
i was splitted the attached string into individual character’s
i need to write each splitted value into excel sheet like this sample
Thanks in advance
you can use generate table or you have to build datatable
step 1 : build datatable give columns as order wise=DT is output
step2 : create array from your string
arr_var=string.split(" "c)
step3 : add datarow
in add datarow DT is your data table and input is array variable
step4 : write range
Can you provide sample workflow?
do you have just one string variable? or do you currently have each column as separate string values?
use a Build Data Table activity to create your table and the relevant columns and then do the below.
If you have them as individual string variables you can use the “Add Data Row” activity.
in the ArrayRow section you can use the following line:
{strDate, strMon, StrTue, strWed, strThur, strFri, strSat, strSun}
in the Dt section just add the variable for your newly created table.
You now have a table and the individual string variables and you can use a normal write/append range to add to your Excel file.
Hi @rsr.chandu,
First, convert the string you have into a list with the split function.
Then, using a loop, add column and default value with add data row for each row.
Regards,
MY
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.