Import Sheet From CSV / XLSX

UiPath.Smartsheet.Activities.ImportSheet

Uses the Smartsheet Import Sheet from CSV / XLSX API to import CSV or XLSX data into a new sheet in the top-level "sheets" folder.

How it works

The following steps are an example of how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

1. Complete the Setup steps.
2. Add the Smartsheet Application Scope activity to your project.
3. Add the Import Sheet activity inside the Smartsheet Application Scope activity.
4. Create an enter values for the Input properties.
5. Enter values for the Output properties. The (Folder ID) and (Workspace ID) cannot both be populated as options.
6. Create and enter an ResponseStatus variable for the Output property.

In the Body of the Activity

• Sheet Name - Desired name of the sheet. This field supports only Strings or String variables.
• Local File Path - File path to the file to upload. This field supports only Strings or String variables.
• Folder Id - The id of the folder to upload the sheet to. Enter a Int64 or Int64 variable.
• Workspace Id - The id of the Workspace to upload the sheet to. Enter a Int64 or Int64 variable.
• Header Row Index - A zero-based integer indicating the row number to use for column names. Enter a Int32 or Int32 variable.
• Primary Column Index - A zero-based integer indicating the column to designate as primary. Enter a Int32 or Int32 variable.
• Sheet - The imported sheet. This field supports only Sheet variables.
• Permalink - The permalink of the new sheet. This field supports only String variables.

Properties

Common

• DisplayName - The display name of the activity. This field supports only Strings or String variables.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

• ResponseStatus - The status of the request (success/failure information). This field supports only ResponseStatus variables.