Assign: Exception has been thrown by the target of an invocation for bigger Excel

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi,

I am trying to extract numbers only from my column name “Yarn TC” and paste it into another column. When I have a Datatable/Excel of only 6 columns it is working fine but with an Excel of about 30 columns I am getting this error: Assign: Exception has been thrown by the target of an invocation

Can someone tell me whats wrong please?

Modified_ASOS_June.xlsx (25.1 KB) ExtractDigits.xaml (7.3 KB)

[NIVED_NAMBIAR (NIVED N)]

Hi @Yudhisteer_Chintaram1
Can u show what u write in assign

also try with row(6) instead of row.item(6)

Regards,
Nived N
Happy Automation

[Pravin_Patil1 (Pravin Patil)]

@Yudhisteer_Chintaram1
I think it’s the same answer I gave in another post…

you are missing to add data column or you are passing the wrong column index to the assign row.item()

Let me know if it’s different issue