Hi All,
I find new information on how to import an Excel file into Dynamics 365 Business Central using AL code. Hence I thought of writing a blog.
Below is the code which shows importing an Excel file in D365 BC Azure/Online model.
Step 1: Create a Code unit
Step 2:Write all the logic required to Import, Read the Excel file, and Insert the data into a target table, In my case it is the Job Journal table.
Step 3: Call this Code unit from a Page Action.
I find new information on how to import an Excel file into Dynamics 365 Business Central using AL code. Hence I thought of writing a blog.
Below is the code which shows importing an Excel file in D365 BC Azure/Online model.
Step 1: Create a Code unit
Step 2:Write all the logic required to Import, Read the Excel file, and Insert the data into a target table, In my case it is the Job Journal table.
Step 3: Call this Code unit from a Page Action.