[Excel] How To Control Font

Reporting Design Cookbook Report Design
1

This recipe demonstrates how to control the font in the Microsoft Excel-format output of a report template.

Steps taken:

  1. Create two report templates (renderInExcel1.rml and renderInExcel2.rml).
  2. In the renderInExcel1.rml file, enter the following script into “Field Properties > Field (Script)”:“01) This is line number 1\n” +
    “02) line number 2\n” +
    “03) line number 3\n” +
    “04) line number 4\n” +
    “05) This is line number 5\n” +
    “06) line number 6\n” +
    “07) line number 7\n” +
    “08) line number 8\n” +
    “09) line number 9\n” +
    “10) line number 10\n” +
    "11) this line is partially hidden"Set the font in “Field Properties > Font > Name” as “Serif”.
  3. In the renderInExcel2.rml file, enter the same script into “Field Properties > Field (Script)”:“01) This is line number 1\n” +
    “02) line number 2\n” +
    “03) line number 3\n” +
    “04) line number 4\n” +
    “05) This is line number 5\n” +
    “06) line number 6\n” +
    “07) line number 7\n” +
    “08) line number 8\n” +
    “09) line number 9\n” +
    “10) line number 10\n” +
    “11) this line is partially hidden”

Set the font in “Field Properties > Font > Name” as “Arial”.

To download the necessary files for this recipe, refer to the attached ZIP package.
HowToFontControl.zip (3.7 KB)