Using excel services in D365

(1) Share

Report

Posted on by David Danh

Hi everyone,

I'm new member .

I'm coding function for import data from excel but that throw exception "The name 'SysExcelApplication' does not denote a class, a table, or an extended data type."

This is my code and these red words is same exception above.

private void importExelInternalDeliveryPrice()
{
SysExcelApplication application;
SysExcelWorkbooks workbooks;
SysExcelWorkbook workbook;
SysExcelWorksheets worksheets;
SysExcelWorksheet worksheet;
SysExcelCells cells;

....

}

I try update model to Application Platform package , but that not effect.

I'm using office 2016 , so i had tried add reference Microsoft.Office.Interop.Excel.dll but that is not OK.

Please help me.

Thanks a lot.

I have the same question (0)

All responses (2)

Answers (0)

David Danh 33 on at

Like (0)

Report

Using excel services in D365

Thank you very much.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,093 Most Valuable Professional on at

Like (1)

Report

Using excel services in D365

Your approach worked in AX, but you need to do it differently in F&O. Utilize EPPlus library; OfficeOpenXml.ExcelPackage is the main class there. You can find examples on Internet, e.g. Import records from Excel using X++ code in D365FO.

(Moved from Dynamics AX forum.)

Was this reply helpful? Yes No