Getting an error while to copy excel data to a datatable variable - value of type 'DocumentFormat.OpenXML.Drawing.Charts.Datatable cannot be coverted to System.DataTable.Data

Surprisingly, I created another Datatable variable and that resolved the issue. I still don’t understand why it works for one variable and not for another. Is this a bug?

1 Like

Your error message is telling to you. First variable has different type. Completely wrong one. Try to use ctrl + k to create variable it will reduce risk of similar mistakes.

1 Like