X++ code to export the records to Excel Sheet from Table dynamically in D365 F&O 

class BASExcelExport
{
                
   
    /// <summary>
    /// Runs the class with the specified arguments.
    /// </summary>
    /// <param name = "_args">The specified arguments.</param>
    public static void main(Args _args)
    {
        
        BASEmployeeDetails employeeDetails;

        DocuFileSaveResult saveResult =

DocuFileSave::promptForSaveLocation("@ApplicationPlatform:OfficeDefaultWorkbookFileName","xlsx", null, "excel create and export");

        if (saveResult&& saveResult.parmAction() != DocuFileSaveAction::Cancel)

        {

            saveResult.parmOpenParameters('web=1');

            saveResult.parmOpenInNewWindow(false);

            System.IO.Stream
workbookStream = new System.IO.MemoryStream();

            System.IO.MemoryStream
memoryStream = new System.IO.MemoryStream();

            using(var package = new OfficeOpenXml.ExcelPackage(memoryStream))


            {

                var worksheets = package.get_Workbook().get_Worksheets();

                var worksheet = worksheets.Add("Sheet1");

                var cells = worksheet.get_Cells();

                var currentRow=1 ;

                /*-------HEADER PART -------*/

                var cell = cells.get_Item(currentRow,1);

                cell.set_Value("Employee ID");

                cell=null;

                cell = cells.get_Item(currentRow,2);

                cell.set_Value("Employee Name");

                /*-------HEADER PART END-------*/

/*-------Insert all the records-------*/

while select employeeDetails

{

    currentRow ++;

    cell = null;

    cell = cells.get_Item(currentRow, 1);

    cell.set_Value(employeeDetails.EmpId);

    cell = null;

    cell = cells.get_Item(currentRow, 2);

    cell.set_Value(employeeDetails.EmpName);

}

               

                package.Save();


            }

            memoryStream.Seek(0,System.IO.SeekOrigin::Begin);

            //Download the file.

            DocuFileSave::processSaveResult(memoryStream,saveResult);

        }


    }

}

Comments

Post a Comment

Popular posts from this blog

How to Create a wizard in x++ d365

Image
 step1: Create a form and apply form pattern as wizard step2 : create a class and extend the class with SysWizard. code :            class BAS_WIzardScreen extends SysWizard {     #MACROLIB.AviFiles     FormName formname()     {         return formstr(BAS_WIzardForm);  // name of the wizard form     }     public void run()     {         info(strFmt("Thankyou"));     }     public void setupNavigation()     {     }     public boolean validate()     {         return true;     }     public static str description()     {         return "BASOFA WIZARD";  // title of the wizard     }     public static void main(Args _args)     {         BAS_WIzardScreen wizard = new BAS_WIz...
Read more

how to post trade agreement journals automatically using x++ code

  In Microsoft Dynamics AX, you can post trade agreement journals automatically using X++ code. Here are the steps to do so: Create a new job in X++. Write a code to fetch data from the trade agreement table. Create a journal header and journal lines based on the fetched data. Call the post() method of the journal header to post the journal. Repeat steps 2 to 4 for each trade agreement. Here's a sample code in X++: static void postTradeAgreementJournals(Args _args) { TradeAgreementTable tradeAgreementTable; GeneralJournalHeader generalJournalHeader; GeneralJournalLine generalJournalLine; // Fetch data from the Trade Agreement table select tradeAgreementTable where tradeAgreementTable.JournalPosting == NoYes::No; // Loop through each trade agreement while (tradeAgreementTable) { // Create a journal header generalJournalHeader = new GeneralJournalHeader(); generalJournalHeader.initValue(); generalJournalHeader.tra...
Read more

X++ code to CREATE AND POST A TRADE AGREEMENT IN MICROSOFT DYNAMICS 365 in D365 F & O

Reuirement : I have to create a table called BASTradeAgreementTable with fields like following Item number Product Name ToDate FromDate InventSiteId InventLocationId Amount From Unit Step2: After Creating Table I have to create a form and add the created table into the form datasource and add all the fields of that datasource to form grid. I have to create a button called Post whenever user clicks on that button i have to create and post Trade Agreement Journals with the data provided in the form grid. [Control("Button")]     class Post     {         /// <summary>         ///         /// </summary>         public void clicked()         {             int             recordsCount;              BASTradeAgreementTable    tradeAgreement;     ...
Read more