Disallow conversion

hi, what does this error mean

here is the type argument as datatable

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?

Regards,

hi @Pyx ,

Can you try this?

DtSet.Tables.Cast(of datatable)

image

hi i cnt seem to find typearguement to change

Hi @Pyx

Check property panel. Change type argument to DataTable.

Hi @Pyx Can you remove append range and reconfigure again

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

Regards,

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

it works now, thanks! but i have another error

could it be due to the placement of the activity?

@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.

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

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

i disabled that activity, instead appending has issues

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

@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

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

@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


stated that excel doesnt exist

@Pyx

It needs to be in string format: “Excel”

tried a different one and issue is with classtype