I am automating file transfer within remote desktop and FTP servers. Storing static path in excel is not a problem as they are already stored as string but for example I have a path like this:
“/” + csoNames(i) + “/” + csoArray(i)(counterSubDivArr) + “/testing/”
Currently if I read the cell in which it is stored, it gives me a string as it is and the array elements aren’t displayed. How do I store it in excel and get it in UiPath for further functions.
Hie @Khadija_Zeb not getting your point … and if your means you want to convert your string variable into datatable you can use [Generate DataTable from Text] Activity it convert all string variable into datable format … hope this is your query…
Cheers Happy Automation 
you cannot bypass compilation and therefore it will return the string for a code snippet
“/” + csoNames(i) + “/” + csoArray(i)(counterSubDivArr) + “/testing/”
As you can see this path is using two different arrays, now if I save it in the UiPath as is then there’s no problem because the two arrays that I am using are already initialized in UiPath e.g., it will return the first path in for each like this “/cso1312/13121/testing”.
But if I get it from excel, it doesn’t give the actual array element but returns the whole text including arrays as it was written.
I want it to read array elements and return me a path like this: “/cso1312/13121/testing”.
As mentioned:
in other words: Code snippets cannot be externalized within excel, when this snippet requires compilation
Instead of putting this code snippet in excel, put some placeholder like #foldername#.
When passing this to wherever required, use string.replace to replace this placeholder with actual value.
Thanks,
Ashok 
Ok, it will solve my problem. Thank you
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.