iRobo.Activity.Table Exists

Checks if the provided table name exists within the current Sheet of an Excel file or not.


     Note: 

         Before using Office Activities, check Office Automation prerequisites from Office Page.

         Table Exists is one of the Excel activities that requires Excel Scope Activity.

                               

                                                                               

Properties

Excel

  • SheetName -  Excel Sheet name of current Workbook. Default value: "Sheet1".


Input

  • Table Name - Enter table name to find. (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output 

  • Result -  Return Boolean indicating existence of the specified table. (Mandatory)


Steps of Using Table Exists

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Table Exists Activity into Excel Scope Activity Body.
  3. Enter Table Name in Property Panel.
  4. Specify Output Boolean Variable to check the existence of the provided Table Name.
  5. Click Save button from iRobo Studio Menu to save Workflow.
  6. Click Play button to start the automated process.


Created with the Personal Edition of HelpNDoc: Easily create CHM Help documents