...
Fieldname | Use the Fieldname modifier to insert database column headings in a spreadsheet. For example, if template cell C5 contains *%%=Products.#2(fieldname)* \ExcelWriter will insert the name of column 2 in C5. | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Uppercase | If a data marker includes the Uppercase modifier, all text values in the data marker column or cell will be displayed in uppercase. If a data marker includes both the Uppercase and Lowercase modifiers, the last will be applied to cell values. | |||||||||||||
Lowercase | If a data marker includes the Lowercase modifier, all text values in the data marker column or cell will be displayed in lowercase. If a data marker includes both the Uppercase and Lowercase modifiers, the last will be applied to cell values. | |||||||||||||
Optional | By default, if a data marker's data source name or column name is not bound to a data source in the script, an error will occur. If a data marker contains the Optional modifier, and the data marker is not bound by name to a data source, ExcelWriter will discard the data marker in the generated spreadsheet and will not throw an error. \This modifier makes both a data marker's data source and column optional. For example, for this data marker: *%%=Orders.OrderID(Optional)* \If either the data source "Orders," or the column "OrderId" does not exist, the data marker will be removed without error. {note}* If a data marker contains a data source number and/or field number (for example %%=#7.#3) and is not bound to a data source in script, the data marker will be removed without error whether the "Optional" modifier is present or not.
|