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