Get datatable from webpage into a single 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.


This is how i am currently getting my results, but i want them all to be pasted in one cell.

Hi @Attia_Nafees

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

1 Like

I tried this but it throw validation error

Hi @Attia_Nafees

Can you send the screen shot of the error?

Regards


this is the error i am encountering

Hi @Attia_Nafees

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

Hi @Attia_Nafees

Is that any specific reason to use studioX /we can achive in studio easily!

Regards

another error

I thought studioX would be simpler

Hi @Attia_Nafees

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:


Step2:
image
Step3:

step4:
image

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

1 Like



Tried still encountering the same error

Hi @Attia_Nafees

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

Hi @Attia_Nafees

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

@Attia_Nafees

Check with the below link for learning!

And Check with the excel automation video guidance below!

Regards

1 Like