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.
- Open the template builder and choose File - New Sheet to display an
empty
(eSuite spreadsheet)with its
InfoCenter.
- Label rows 2 - 4 "Travel," "Hotel," and "Meals."
- Label columns B - E "Day 1," "Day 2," "Day 3," and "Total."
- Enter the following formulas in cells E2, E3, and E4: @SUM(B2..D2),
@SUM(B3..D3), @SUM(B4..D4).
- 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.
- Close the Number format panel.
- 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.
- 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.