Need help in extracting excel data using custom assemblies / dll like Microsoft.Office.Interlop.Excel.dll , ClosedXml.dll . I have Imported required dll in the client folder which is a initial directory after selecting assembly reference manager. I can select dll but cannot reference it. I have also tried setting a custom directory through application server configuration but it did not worked.
You shouldn’t need custom assemblies to read excel data, you can reference DocumentFormat.OpenXML.dll to achieve this which Epicor provides already
2 Likes