Adding Style Properties in the Excel Report

Owned by Rojer Benny CTOO
Last updated: yesterday at 11:18 am by DevaDarshini.S
5 min read

eMACH-Sigma enables user to add styles for the columns and various report parameters of the XLSX report according to the user needs using default style properties available in eMACH-Sigma.

In the following screenshot of an Excel report, various styles are included.

image-20240313-120246.png

To make use of these styles in XLSX report follow the below steps:

  1. Configure the report with the required configurations in Report Maintenance tab. For detailed information on creating reports in eMACH-Sigma Studio, refer Configuring Reports.

    image-20240313-120509.png

  2. Click Template Designer icon.

  3. Drag and Drop the required column or report parameters in the design area. To know more about the functionalities of template designer, refer Report Templates.

  4. Click on the added column or report parameter to view the additional configuration settings.

  5. Add the required style property in the Parent Container Style field from the available style properties mentioned below

  • TitleField

  • ColumnHeader

  • block-content-left-align

  • block-content-center-align

  • block-content-right-align

  • default

 

Note:

Make sure to follow the same style property name in the Parent Container style to view the styles for the column or report parameters.

Note:

The user can also modify/add the styles properties according to their requirement in the ct_style_config table available in eMACH-Sigma schema. The Styles are in JSON format.

The user has to add the necessary styles properties in the same JSON format mentioned in the CONFIG_JSON column.

TABLE COLUMN

VALUES

APPLICATION_ID

eMACH-Sigma

STYLE_ID

STYLE-1

FORMAT

XLSX

CONFIG_JSON

{ "CustomStyles": { "default": { "fillBGColor": { "red": 255, "green": 255, "blue": 255 }, "fillFGColor": { "red": 255, "green": 255, "blue": 255 }, "fontFamily": "Arial", "fontSize": 10, "topBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "leftBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "rightBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "bottomBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "hAlign": "LEFT" }, "block-content-left-align": { "fillBGColor": { "red": 255, "green": 255, "blue": 255 }, "fillFGColor": { "red": 255, "green": 255, "blue": 255 }, "fontFamily": "Arial", "fontSize": 12, "topBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "leftBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "rightBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "bottomBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "hAlign": "LEFT" }, "block-content-center-align": { "fillBGColor": { "red": 255, "green": 255, "blue": 255 }, "fillFGColor": { "red": 255, "green": 255, "blue": 255 }, "fontFamily": "Arial", "fontSize": 12, "topBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "leftBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "rightBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "bottomBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "hAlign": "CENTER" }, "block-content-right-align": { "fillBGColor": { "red": 255, "green": 255, "blue": 255 }, "fillFGColor": { "red": 255, "green": 255, "blue": 255 }, "fontFamily": "Arial", "fontSize": 12, "topBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "leftBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "rightBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "bottomBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "hAlign": "RIGHT" }, "ColumnHeader": { "fillBGColor": { "red": 0, "green": 0, "blue": 128 }, "fillFGColor": { "red": 0, "green": 0, "blue": 128 }, "fontFamily": "Arial", "fontSize": 10, "fontColor": { "red": 255, "green": 255, "blue": 255 }, "isBold": true, "topBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "leftBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "rightBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "bottomBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "hAlign": "CENTER" }, "TitleField": { "fillBGColor": { "red": 255, "green": 255, "blue": 255 }, "fillFGColor": { "red": 255, "green": 255, "blue": 255 }, "fontFamily": "Arial", "fontSize": 16, "isBold": true, "topBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "leftBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "rightBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "bottomBorder": { "color": { "red": 166, "green": 166, "blue": 166 }, "style": "THIN" }, "hAlign": "CENTER" } } }

  1. Click Save icon to save all the configurations done in Template Designer.

  2. Click Save to view the configured report in XLSX format with the specified styles.

Â