Cloud Pak for Business Automation

Cloud Pak for Business Automation

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  IBM BAW - BPMUI Toolkit - Data Export Control -Excel File Formatting Features

    Posted Thu September 11, 2025 12:04 AM
    Edited by Remya Raj Thu September 11, 2025 12:06 AM

    Hi All,

    Using BPMUI toolkit - Data Export control, can we export an excel file which includes row coloring and font coloring. Is it possible to customize the Data Export control and implement these features?

    Please suggest possible solutions for this use case. 

    Thanks. 



    ------------------------------
    Remya Raj
    ------------------------------



  • 2.  RE: IBM BAW - BPMUI Toolkit - Data Export Control -Excel File Formatting Features

    Posted Tue October 14, 2025 02:13 AM

    Hi Remya,

    The default Data Export control in IBM BPMUI Toolkit supports exporting to .xlsx and .csv formats only. It does not natively support styling such as row or font coloring in the exported Excel files.

    You can extend the Data Export control using JavaScript and XML manipulation techniques.

    The exported Excel file is essentially a ZIP archive containing XML files (sheet1.xml, styles.xml, etc.). You can modify these files during export to apply styles.

    Use the customize function in the export logic to access and modify the XML structure of the Excel file.

    Example: You can target specific rows or cells and apply styles by setting the s attribute to a style index defined in styles.xml.

    customize: function(xlsx) {
      var sheet = xlsx.xl.worksheets['sheet1.xml'];
      $('row c[r^="A"]', sheet).attr('s', '25'); // Apply style index 25 to column A
    }


    ------------------------------
    Sravan Kumar
    ------------------------------

    Original Message


  • 3.  RE: IBM BAW - BPMUI Toolkit - Data Export Control -Excel File Formatting Features

    Posted Thu October 16, 2025 03:46 AM
    Edited by Remya Raj Thu October 16, 2025 03:46 AM

    Hi Sravan,

    Can you please provide more details on this, where exactly the custom function to be written to achieve row colouring and font colouring.

    ------------------------------
    Remya Raj
    ------------------------------

    Original Message


  • 4.  RE: IBM BAW - BPMUI Toolkit - Data Export Control -Excel File Formatting Features

    Posted Mon November 03, 2025 06:53 AM

    Hi @Remya Raj sorry I was referring to the wrong data.
    you can try creating a custom coach replicating Data Export Control CV. Extract the code from bpmExt-style.zip from the behavior  section and try to search color option and do trail and error editing the color styles. 



    ------------------------------
    Sravan Kumar
    ------------------------------

    Original Message


  • 5.  RE: IBM BAW - BPMUI Toolkit - Data Export Control -Excel File Formatting Features

    Posted Tue November 04, 2025 10:09 AM

    Hi Remya, I know it's not exactly what you are looking for, but note that it is possible to do number formatting of cells via the on exported cell event.  For example:

    The above will result in a spreadsheet with formatted cells like:

    Cell background colors, fonts, etc, require modifying the styles of the cell in a separate file in the Excel zip.  As Sravan says, the best way to do this is to clone the data export control and add your custom logic.

    Thanks,

    Grant.



    ------------------------------
    Grant Taylor
    ------------------------------

    Original Message


Related Content