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.
