News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Using excel services i...

Finance | Project Operations, Human Resources, ...

Suggested answer

Using excel services in D365

(1) Share

Report

Report

Posted on by David Danh

33

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

David Danh 33 on at

Like (0)

Report

Using excel services in D365

Thank you very much.
Suggested answer

Martin Dráb 230,605 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.)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2

Martin Dráb 230,605 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans