Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Reference: Text-Excel Step Properties

Reference: Text-Excel Step Properties

Common Tab

Property
XML Attribute Name
Description
Step Id
id
The unique ID of the
text-excel
 mediation step within the assembly.
Input
input
Specifies where the
text-excel
 mediation step obtains data as input. There are 5 possible values:
  • message
    : the entire message, including
    rootpart
     and attachments.
  • soapbody
    : the content of the SOAP body from the
    rootpart
     of the message. Only applicable when the input contains a SOAP message.
  • attachment
    : a MIME attachment within the message. You must specify the attachment index.
  • rootpart
    : the content of the root part of a MIME message. If the message isn't MIME, the entire message is selected.
  • variable
    : use a named variable from the
    MediationContext
    .
Output
output
Specifies where the
text-excel
 mediation step directs the output. There are 5 possible values:
  • message
    : the entire message, including
    rootpart
     and attachments. This value creates a new message, effectively removing any attachments.
  • soapbody
    : the content of the SOAP body from the
    rootpart
     of the message.
  • attachment
    : a MIME attachment to the message. You must specify the attachment index.
  • rootpart
    : the content of the root part of a MIME message, or if the message isn't MIME, the message itself. This value preserves any attachments on the original message.
  • variable
    : save the output as a named variable in the
    MediationContext
    .
Style
style
The conversion style of the
text-excel
 mediation step. There are 3 options:
  • XLSX/XLS to Text
    : converts an Excel file of either XLSX or XLS format to a CSV file.
  • Text to XLS
    : converts a CSV file to an Excel file in the XLS format.
  • Text to XLSX
    : converts a CSV file to an Excel file in the XLSX format.
This component streams when converting to or from XLSX.
Excel Style
excel-style
Specifies whether the
text-excel
 mediation step converts an entire Excel workbook or a single Excel sheet.
Excel Sheet Number
excel-sheet-number
The target sheet number to convert in an Excel file.
If you configure the
Excel Style
 property to
workbook
, Workday ignores the
Excel Sheet Number
 setting for your
text-excel
 mediation step.

Advanced Tab

Property
XML Attribute Name
Description
Description
description
A description of the
text-excel
 step that displays in the consolidated log. You can use this feature to describe the step's function and the data on which it is operating.
Execute When
execute-when
A condition that determines whether the
text-excel
 step executes.
Use Values
usevalues
Specifies whether the
text-excel
 mediation step uses the underlying values of the spreadsheet, rather than their formatted values as they display on-screen.