Hy,
I got a data table from amazon and i want to paste all data in one cell on excel. can any suggest me a way.
This is how i am currently getting my results, but i want them all to be pasted in one cell.
Hy,
I got a data table from amazon and i want to paste all data in one cell on excel. can any suggest me a way.
Welcome to community!
You can try with below steps!
Read range the excel with workbook readrange
For each row in read datatable
Assign
LHS
Currentrow(“Seller name”) =
RHS
string.join(“,”, readDt.AsEnumerable().Select(Function (a) a.Field(of string)(“Seller name”).ToString).ToArray())
Outside the body of the loop use
Write range with same readrange path , datatable and sheet name
Regards
Thank you for your response, going to try this and let you now if the problem is solve
I tried this but it throw validation error
What i have told is we can able to do with studio!
If its studio X!
refer to the screenshot below!
Regards
Thank you going to try it now and let you know
Is that any specific reason to use studioX /we can achive in studio easily!
Regards
I thought studioX would be simpler
Not familiar in using studio x!
if you need to achieve in studio means i can provide xaml!
you need to switch from studio x to studio refer to the screen shot below!
for enabling the classic option—>open studio—>
The task would be done in studio as follows below!
Step1:
step4:
The whole process look a like below!
Regards
Alright will try so and let you know
Hi @Attia_Nafees,
The solution provided by @pravin_calvin, would work here.
Let us know if you need any further solutions.
Thanks
Hy, i am going to try it today and let you guys know thank you
You need to create a dt variable as out in read range and pass it in for each row
Regards
how do i create a variable sorry for bothering you so much, i am really new to UIpath
Refer to the xaml below!
Just replace the file path and sheet name as per you excel file!
test_sequence.xaml (7.3 KB)
Regards
Check with the below link for learning!
And Check with the excel automation video guidance below!
Regards