BPM, Workflow, and Case

 View Only
  • 1.  BAW BPMUI Toolkit - DataExport

    Posted Mon January 23, 2023 09:30 AM
    Edited by Kwangho Kim Mon January 30, 2023 07:09 PM
    Hi all

    Using BPMUI toolkit, We can export data as excel file.
    I can export only one excel file include only one sheet.

    My question is that Can I export one excel file include multiple sheets?

    As we know, Created/Exported Test1.excel file and this file have sheet1 & sheet2 etc


    I have tried something but This is impossible using current component. right? 

    Kwangho Kim

  • 2.  RE: BAW BPMUI Toolkit - DataExport

    IBM Champion
    Posted Thu February 02, 2023 11:19 PM
    Hello Kwangho,

    Yes, you are correct, this cannot be achieved using the out of the box component.
    Handling multiple sheets in Excel is not very 
    straightforward, you need to use some external libraries.
    There are multiple ways of doing this, one way could be developing a custom web application implementing a servlet which would use Apache POI.
    You can send the required data to the servlet from UI via HTTP call and in return the servlet would give file stream to download that file from browser.
    Then, you can simply implement a button/ui widget to make that HTTP call from UI.


    Atanu Roy
    Solution Architect
    Salient Process

  • 3.  RE: BAW BPMUI Toolkit - DataExport

    Posted Fri February 03, 2023 12:19 AM
    Hi Atanu 
    Thanks for your update.

    Kwangho Kim