How to copy column data from excel and paste in a web browser in single line format

Help Studio
, , , , , , ,
1

Question - How to copy column data from excel and paste in a web browser in single line format ?

Example -
image

Regards
Naman

2

Hi @Naman_Arora ,

In the image shown, is it the input or the expected output?

Regards,

3

Yes, expected output.

I have used assign activity first to record column data into string variable - dt2.AsEnumerable.Select(Function(column) column.Field(Of String)(“Fruits”)).ToList. Then I have used send hotkey activity to paste the same into browser popup but insteand of pasting in a single line it’s pasting like this - Apple Mango Orange.

Regards
Naman

4

Hi @Naman_Arora ,

Try this:

Join(environment.newline,dt2.AsEnumerable.Select(Function(column) column.Field(Of String)(“Fruits”)).ToList)

5

Hi @Harshith_Adyanthaya

I tried with above code but I’m getting this.

image

Regards
Naman

6

@Harshith_Adyanthaya

I have assigned variable type to -

image

Regards
Naman

7

String.Join(environment.newline,dt2.AsEnumerable.Select(Function(col) col(“Fruits”).Tostring).ToList)

Try this.

8

Output type should be String.

9

@Harshith_Adyanthaya

Still getting the same
image

yes output type is string only -
image

Regards
Naman

10

@Naman_Arora ,

As @Harshith_Adyanthaya mentioned, use string.join instead of just join

Regards

1 Like
11

@Naman_Arora

Yes, use String.Join as mentioned previously.

String.Join(environment.newline,dt2.AsEnumerable.Select(Function(col) col(“Fruits”).Tostring).ToList)

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.