Changing reference to [Microsoft.Office.Interop.Excel.dll]

[loginerror (Maciej Kuźmicz)]

Hi @Haifisch

Could you try this method and see if it will solve your needs?

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

This behaviour is an outcome of the dependency management introduced since 2018.3. Basically, the only way to load an assembly into the project is to have an activity that will use said dependency.

There might be a workaround (although not tested), in which you add the custom activity to the project by dragging it into the sequence and then saving and restarting the project. It might keep it afterwards even after you delete said activity.
(please let us know if such workaround worked for you )

We will definitely look for ways to improve this behaviour with future UI improvements in upcoming releases.