Template builder example

The following example demonstrates how to build a template using the eSuite Spreadsheet template builder and how to load the template in an HTML file.

  1. Open the template builder and choose File - New Sheet to display an empty (eSuite spreadsheet)with its InfoCenter.
  2. Label rows 2 - 4 "Travel," "Hotel," and "Meals."
  3. Label columns B - E "Day 1," "Day 2," "Day 3," and "Total."
  4. Enter the following formulas in cells E2, E3, and E4: @SUM(B2..D2), @SUM(B3..D3), @SUM(B4..D4).
  5. Select cells B2..E4, then, in the InfoCenter, click Number format and select currency in the Category box and US Dollar in the Format box.
  6. Close the Number format panel.
  7. Choose File - Save from the Template Builder menu and save the template as Expenses3.html-wk. Click here to see the HTML code that the template builder generates.
  8. Create a file (Exp.html) that loads the template. The file should look like this.
    Click here to see the way a template displays when you open Exp.html.