Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Using excel services i...
Finance forum
Suggested answer

Using excel services in D365

Posted on by 15
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.
  • CU13080802-3 Profile Picture
    CU13080802-3 15 on at
    Using excel services in D365
    Thank you very much.
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 228,112 Most Valuable Professional on at
    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

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans