iRobo.Activity.Get Table Names

Returns all table names within current Sheet in an Excel file.


     Note: 

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

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

                                                                                                               

Properties

Excel

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


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output 

  • Output -  Return a List of String Variable of all table names within the Sheet. (Mandatory)


Steps of Using Get Table Names

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Get Table Names Activity into Excel Scope Activity Body.
  3. Create a List of String Variable and add it to Output field in Property Panel to return all table names within the Sheet. 
  4. Click Save button from iRobo Studio Menu to save Workflow.
  5. Click Play button to start the automated process.


Created with the Personal Edition of HelpNDoc: Benefits of a Help Authoring Tool