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:
Sent: Thu September 11, 2025 12:04 AM
From: Remya Raj
Subject: IBM BAW - BPMUI Toolkit - Data Export Control -Excel File Formatting Features
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
------------------------------