Disallow conversion

Help Studio
, ,
1

hi, what does this error mean

image
image1920×1080 213 KB

3

here is the type argument as datatable

image
image1920×1080 267 KB

4

Hii @Pyx ,
Instead of Parallel for each can’t you use For each Activity and provide dataset.Tables by keeping the type argument as System.DataTable?

image
image1090×177 8.99 KB

Regards,

5

hi @Pyx ,

Can you try this?

DtSet.Tables.Cast(of datatable)

image

6

hi i cnt seem to find typearguement to change

image
image1920×1080 232 KB

7

Hi @Pyx

Check property panel. Change type argument to DataTable.

image
image981×277 11.9 KB

8

Hi @Pyx Can you remove append range and reconfigure again

9

@Pyx ,
Can you please double check
Its working for me

image
image1089×293 12.8 KB

Regards,

10

hi my properties panel completely doesnt show, could it be due to the update?

image
image1920×1080 214 KB

11

it works now, thanks! but i have another error

image
image1920×1080 245 KB

could it be due to the placement of the activity?

12

@Pyx ,
Yes in the latest version there is no option to change the argument. This might be a bug not sure.
Bt inorder to use dataset.tables you need to convert the type argument to DataTable.

13

i used parallel for each with the others suggestion and now my script has another issue,

image
image1920×1080 245 KB

14

@Pyx , can you debug and verify which activity is throwing this error and if data exists in dataset?

15

i disabled that activity, instead appending has issues

image
image1920×1080 243 KB

this shows that the excel is being usedbut i dont have it open or used…

16

@Pyx The error is giving at Present Validation Station . It looks like there is an issue Document Object Model. Can you please check you are giving the right value

17

@Pyx Can you use Kill Process activity to kill excel before excel scope

18

@Pyx
Before Append Range, keep Kill Process and in properties Process Name as EXCEL

So, if there is any instance opened that will be killed before the Append Range

19

image
image1920×1080 223 KB

stated that excel doesnt exist

20

@Pyx

It needs to be in string format: “Excel”

21

image
image1920×1080 202 KB

tried a different one and issue is with classtype