XLS Templates

Introduction

XLS templates allow you to merge data from Salesforce into Microsoft Excel XLS spreadsheets. They are built with the S-Docs Template Editor in Salesforce.

Main Advantages

XLS templates allow you to merge simple to complex related lists and merge fields into Excel spreadsheets. You can also write formulas directly in the template editor, which will evaluate when the XLS spreadsheet is generated.

Supported Features

Feature Supported?
Merge Fields
Related Lists
Conditional Logic
Live Edit
Runtime Prompts
HTML/CSS Source Editing
Named Queries
Template Header & Footer
Insert Component Templates
Mass Merge (Batch Generation)
Collect e-signatures with S-Sign

Recommended For

XLS templates are recommended for larger spreadsheets that require dynamic data, such as product rate sheets.

Main Limitations

Consider the following XLS limitations.

  • Only one sheet is supported per template; multiple sheets are not supported
  • While HTML table elements can be used to define each cell, it can sometimes be difficult to predict which cell a piece of data will be merged into
  • DOCX &  PPTX limitations also apply to XLS templates

Tags: , ,

Was this helpful?