How to Import Records from Excel Using X++ Code in D365FO

  How to Import Records from Excel Using X++ Code in D365FO   Include the below namespace in X++ code it will requires to import Excel. Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange;   In addition to the basic reference, include (Directory and DirectoryUpgrade Packages) X++ Code: Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; class ReadExcel {   public static void main(Args _args)    {     Int id;     Str Name;      System.IO.Stream stream;       ExcelSpreadsheetName sheet;              FileUploadBuild fileUpload,fileUploadBuild;       DialogGroup dialogUploadGroup;       FormBuildControl formBuildControl;   ...

D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++

 D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++


class DemoRefresh

{

static void main(Args args)

{

Table                                     table;

FormDataSource                 formDataSource;

;

 

table = args.record();

 

if (table.RecId)

{

formDataSource = args.record().dataSource();

 

ttsbegin;

table.selectForUpdate(true);

table.field1 = “ABC”;

table.doUpdate();

 

formDataSource.executeQuery();

 formDataSource.refresh();

 

ttscommit;

info(table updated');

}

} 

}


Comments

Popular posts from this blog

Passing Args from one Form to another Form in dynamics AX

CREATE AND POSTING PURCHASE ORDER THROUGH X++ DYNAMICS AX