web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Inside Microsoft Dynamics 365 / Import records from Excel u...

Import records from Excel using X++ code in D365FO

Views (3121)
dasdasd Profile Picture dasdasd 841
In this blog I will discuss how we can import records from Excel file in Dynamics 365 Finance and Operations.

Please see below screenshot with source code explanation:

Explanation of Source Code (1.1):
  • Add / Use following namespaces in the class. 


Explanation of Source Code (1.2):
  • Initialize and declare classes and data types.
  • Create a dialog object, which will open as form.
  • Add controls (Import, Upload and buttons).















Explanation of Source Code (1.3):
  • Get and load Excel file.
  • Get the row count for record iteration.
  • Iterate record and get the columns values on every iteration.















Result:
























That is all you need to do for creating a class which imports record from Excel.

This was originally posted here.

Comments

*This post is locked for comments