Skip to main content
Version: Next

Create Excel from List

Serializes a list from the context into Excel format. Requires XLSX.

Parameter Reference

ParameterDescriptionSupports TokensDefault
List NameDetermines which list entries are serialized. Can contain My Tokens.YesNone
FieldsProvide a list of fields to serialize.NoNone
Include All FieldsOr select this option to serialize all fields.NoNone
Remove Field NamesRemove the field names from the serialization.NoNone
Use excel formulasWhen a cell has a value that starts with = it will write it as a excel formula. Example: =Sum(A1,A2)To escape the = add a ' in front of it.NoNone
CriteriaProvide criteria to determine which entries are serialized.NoNone
PatternOptionally provide a pattern to use for filenames on the server. For example "[User:Username]-avatar". Leave blank to use the original filename. Supports My TokensYesNone
Handle DuplicatesNoRename
File PasswordAdd a password to the file. Use this if you don't want other to see the data. Supports My TokensYesNone
Worksheet PasswordAdd a password to the worksheet. Use this if you want other to see the data but not change it. Supports My TokensYesNone
FolderFolder to write the Excel file into.NoNone
Store Absolute URLOptionally provide a token name where to Store Absolute URL. The token can be used in next actions down the stack.NoNone
Store Relative URLOptionally provide a token name where to Store Relative URL. The token can be used in next actions down the stack.NoNone
Store Physical PathOptionally provide a token name where to Store Physical Path. The token can be used in next actions down the stack.NoNone
Store LinkClick UrlOptionally provide a token name where to Store the LinkClick Url. The token can be used in next actions down the stack.NoNone
Disable Force DownloadDisables LinkClick URL force download feature.NoNone