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;       Dialog dialog=new Dialog("Excel Import using dialog");       dialogUploadGroup=dialog.addGroup("@SYS54759");       formBuildControl=dialog.formBuildDesign().control(dialogUploadGroup.name());    

Split a string into a container in Microsoft Dynamics 365 FO using X++


Split a string into a container in Microsoft Dynamics 365 FO using X++




Some times when developing we need some string of which we only need a segment of the string,
Code :

        List _list      new List(Types::String); 
        Container     con;
        ListIterator  iterator;
        str                   String1;
        ;

        String 1         "Test-test1-test2 ";

        _list               Global::strSplit(String1,"-");
        Iterator         =new ListIterator(_list);

        while (iterator.more())
        {
            con += iterator.value();
            iterator.next();
           info(conPeek(con,conLen(con)));// retrieve the elements from the container by the index.
        }

Comments

Popular posts from this blog

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

Customize SSRS report using extension in D365FO

CREATE AND POSTING PURCHASE ORDER THROUGH X++ DYNAMICS AX