Skip to main content
Version: 1.27 (Current)

Create Excel from SQL query

Serializes the result of an SQL Query into Excel format. Optimized to use with large amounts of data.

Parameter Reference

ParameterDescriptionSupports TokensDefault
DatabaseNoNone
Override Connection StringBy default, the SQL will run against the built-in database or the selected Connection. Use this field to override the connection string. Also supports the name of a connection string from the web.config. It will respect the Provider (ODBC, SqlClient, etc.). Can contain Tokens.NoNone
Query TimeoutSet a time in seconds after which a query will time out. The default is set to 10 minutes or 600 seconds. This parameter can't be negative or under 10 seconds. Can contain Tokens.NoNone
SQL QuerySQL to execute. Can contain Tokens. WARNING! We encourage using binding parameters instead of using the tokens directly on sql query. Just use @param instead of [token] and bind below values as shown: Parameter Name: param ; Parameter Value: [token]. This will keep your database safe.NoNone
Bind TokensBind the parameters above with a value or token. e.g. P. Name:param, P. Value:[token]NoNone
Add Column NamesRemove the field names from the serialization.NoTrue
FolderFolder to write the Excel file into.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 TokensNoNone
Handle DuplicatesNoRename
File PasswordAdd a password to the file. Use this if you don't want other to see the data. Supports TokensNoNone
Worksheet PasswordAdd a password to the worksheet. Use this if you want other to see the data but not change it. Supports TokensNoNone
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
Store File IDOptionally provide a token name where to Store the DNN File ID. The token can be used in next actions down the stack.NoNone
Disable Force DownloadDisables LinkClick URL force download feature.NoNone