Read Excel file using OpenXMLSDK Dynamics 365(AX-7)

Following is code you can use to read Excel using Open XML.

using DocumentFormat.OpenXml;
using System;
using System.Linq;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

public class SLAX7_ImportClass
{

public void testRun()
{
OXMLSpreadsheetDocument_RU document = OXMLSpreadsheetDocument_RU::construct("C:\\AX\\Test.xlsx");
OXMLWorkBook_RU workbook = OXMLWorkBook_RU::construct(document);

OXMLWorksheet_RU worksheet = workbook.getWorksheet(1);

OXMLRow_RU row = worksheet.row(1);
OXMLCell_RU cell = Row.cell(1);
Global::info(strFmt('%1',cell.getValue()));

}

}

Support Faryal's Cusine

Process Data packages

Following are the steps to create Process data packages using LCS and apply to your environment.

Step-1 Navigate to Data Management Workspace and click on Export Tile.

Reference screenshot

Step-2 select any entity and export the data in Excel. Which we will use in the next step. then click on download the package.

Reference screenshot

Step-3 Now login to LCS and navigate to Assets library and click on the data packages Tab.

Step-4 Add the New data package and upload the package. which we downloaded in step-2.

Reference screenshot

Step-5 Now click on Process Data Packages and click on the + icon to add a new PDP.

Step-6 Pre-requisite Business Process required to create Process Data Package.

Step-7 Click on + Icon to add Process data packages. Popup will appear fill out the required fields and click on confirm.

Reference screenshot

Step-8 New screen will appear in 3 to 4 seconds.

Step-9 Select the business process (Step-6) and click on Next.

Reference screenshot

Step-10 Now click on select data packages and select your required package from the popup and click confirm.

Reference screenshot

Step-11 Add the package dependency if any. in my case there is no dependency. so I skipped this step and click on next for the last step of this wizard.

Reference screenshot