Workflow Activity Pack Documentation

  1. Home
  2. Docs
  3. Workflow Activity Pack Documentation
  4. Conversion Activity Reference
  5. Features to Spreadsheet

Features to Spreadsheet

Description

Features to Spreadsheet converts an array of Esri FeatureSets into a spreadsheet. Each sheet will represent a FeatureSet. This activty supports the creation of Microsoft Excel (.xls and .xlsx) and OpenDocument (.ods) spreadsheet formats.

Offline Support

Supported. Please contact us directly to license for offline support and installation instructions.

Example Workflow and Output Files

To open the sample workflow in Workflow Designer:

    • In Workflow Designer, click File in the sidebar
    • Click Open by URL and paste in the following url:
      https://www.arcgis.com/home/item.html?id=29889f9ee9784b38a6e593e976b31f90
    • To Save, click File in the Workflow Designer sidebar, and click Save.

Known Issues

Error: WF: activity error
Message: featureWsName is not defined

This error is potentially improperly reporting an issue. We see this error occur when users are merging or creating ESRI FeatureSets on-the-fly in Geocortex Workflow. The issue stems from the current Create FeatureSet activity providing an input to assign the “Fields” node of the FeatureSet. The “Fields” node of the FeatureSet is used to assign the column names on the Workbook Sheet. If these are missing, the activity sends the above error.

Workaround: Use an Evaluate Expression activity to populate or update the Fields node of the FeatureSet before sending the FeatureSet to the Features to Spreadsheet activity:

=$tempFeatureSet.featureSet.fields=$sourceFeatureSet.results.fields

We will be updating the Workflow with additional logic to handle FeatureSet with missing Fields node.

Inputs

Array of FeatureSets

Required
Type: Object[]
Object Type: esri.FeatureSet

An array of Esri FeatureSets to convert to individual sheets within a spreadsheet workbook.

Array of FeatureSet Names

Required
Type: String[]

Array of strings to provide sheet names for the array of Esri FeatureSets input. The order of the string array should match the Esri FeatureSet array.

Include Schema Sheets

Optional
Type: Boolean

Boolean to include an additional sheet of FeatureSet schemas. This can be used when uploading data to assure that datatypes are respected and for other purposes.

Outputs

Result

Type: Object
Properties:
    Blob: Type: BLOB
    Response:  Type: Object

A response object containing the file BLOB and a response Object.

Properties

ID

Optional

The activity’s ID, which is used in other activities to access the activity’s output. The ID must be unique across the entire workflow and it’s subworkflows – two activities cannot have the same ID.

You might want to change the ID to shorten it. Shorter IDs make expressions more compact.

Display Name

Optional

The activity’s name in Workflow Designer. The display name appears at the top of the activity on the design surface. The default display name for this activity is Feature to Spreadsheet.

You might want to change the display name to a name that describes what the activity does in the context of your workflow. Description names make workflows easier to understand and maintain.

Description

Optional

A description of what the activity does. The description appears below the activity’s display name.

Use the description to record what the activity does in the context of the workflow. Descriptions make workflows easier to understand and maintain.

Was this article helpful to you? Yes No