Excel to Datatable
This activity is used to convert an excel sheet to a new datatable.
Technical Reference:
|
|
INPUT |
IncludeColumnHeaders: Check this box to include column headers to the table. |
|
SheetName: Specify the name of the sheet which has to be displayed in table format. |
||
|
MISC |
Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes. |
|
|
SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.” True: Continues to execute the workflow irrespective of any error thrown. False: Stops the workflow if it throws any error |
||
|
Version: It specifies the version of the excel automation feature in use |
||
|
OUTPUT |
Datatable: This is not a mandatory field. However, to see the output in a table format, we must declare a variable here. |
|
|
Result: Define a Boolean value to validate the success state of the activity. |
*Mandatory field to execute the workflow
The following activity illustrates on how we can use the Excel to datatable activity to get the details on the excel file to be displayed on a datatable.
Example:
1. Drag and drop a get excel object activity to the workflow.
2. Enter the file path of the excel file in which the worksheet to be worked on is present.
3. Drag and drop an excel to datatable activity into the Get Excel object activity.
4. Click on the excel to datatable activity.
5. Specify the name of the worksheet which has. to be displayed as a datatable
6. Declare a variable in the datatable box of the output segment.
7. Drag and drop a table viewer activity from the datatable automation feature.
8. Enter the same variable declared above to the input table of the data table property box.
9. Give a title to the table
10. Execute the activity
The bot executes the activity and displays the values in the specified worksheet in a table.