Export to Excel

Parameter

Description

Example

Attributes:

[Mandatory] Enter attributes (comma separated) to be exported. Attribute names will be used as column titles in row 3. To use other words as column titles, use | to map the attribute to the column title. Leave empty to include all session attributes. Supports SESSION(), but will only use the value from the first Session Object. 

givenName, lastName, uid

givenName|Firstname, lastName|Lastname, uid|User ID

Sheet Title:

[Optional] Will be used both as sheet title and as title in cell A1. If the field is left blank, default title = AAM Export. Supports SESSION(), but will only use the value from the first Session Object.

Users

Auto Resize Columns (true/false):

[Optional] Adjusts the column width to fit the contents. Overrides ‘Static Column Width (mm)’ if set to true. Default value = false.

true

Static Column Width (mm):

[Optional] Static column width in millimeters. Supports SESSION(), but will only use the value from the first Session Object.

40

File Name:

[Optional] The name of the Excel file. Default file name is aamReport. Supports SESSION(), but will only use the value from the first Session Object.

Users_in_London

Directory Path:

[Optional] The directory path where the Excel file shall reside. If left empty, Excel sheet is not saved to file. Supports SESSION(), but will only use the value from the first Session Object.

C:\documents

Overwrite Existing File (true/false):

[Optional] If an existing Excel file should be overwritten or not. If false, existing file will be kept and a new file will be created with a random name filename[random number].(excel extension). Example excelexport5006780627860564089.xls. Default value = false

true

File Format (xls/xlsx):

[Optional] Excel file format. Allowable row ranges: xls=(0-65535), xlxs (0-1048576). Default value = xls.

xlsx

E-mail Address(‘s):

[Optional] Enter the e-mail recipients address(‘s) (comma separated). If left empty, no e-mails are sent. Supports SESSION(), but will only use the value from the first Session Object.

admin@company.com

E-mail Subject:

[Optional] The e-mail subject. Supports SESSION(), but will only use the value from the first Session Object.

Users in London

E-mail Message:

[Optional] The e-mail message. Supports SESSION(), but will only use the value from the first Session Object.

Here is a list of all our users in London.

Parameter

Value

Attributes:

Lastname, Firstname, uid|User ID, Password

Sheet Title:

New Users

Auto Resize Columns (true/false):

true

Static Column Width (mm):

[BLANK]

File Name:

[BLANK]

Directory Path:

[BLANK]

Overwrite Existing File (true/false):

[BLANK]

File Format (xls/xlsx):

xlsx

E-mail Address(‘s):

account-admin@company.com

E-mail Subject:

New Users SESSION(date)

E-mail Message:

Attached is a list of new users created today.