Variable Type conversion

studio

#1

How to convert data type from ‘Generic Value to system.data table’.
As I am getting error.
I am trying to copy a row from one application and pasting that into excel using build data table.
I am using ctrl+c hot key to get data from application and then when I trying to put that into add data row, it is giving me compile error regarding variable conversion. Please suggest. Thanks!


#2

Hello!

Have you tried to use the “Array Row” property to fill the Data Table instead of “Data Row”?

Try something like this:

imageimage

Hope It Helps!

Regards,


#3

Thanks, now I have tried this but getting data in single cell instead of separated column. Please suggest


#4

Just separate with comma to add the value on another column.

Example: {testVariable1, testVariable2, testVariable3}


#5

No actually, I have copied my data using ctrl+c from other application and stored in a variable and now I am using that variable in my arrayrow as {DT}. How can I separate that? Attaching the screen print.Also my excel has the column around 50 but I am getting values for certain columns(missing in between). Please attach.

im1im3im2


#6

you need to split the clipboard data by String.Split(), you should get exact columns with data then.