iRobo.Activity.Find Last Column

Finds last column of an Excel Sheet.

       

     Note: 

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

         Find Last Column 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 

  • Column Index -  Return last used Column index. (Mandatory)
  • Column Name -  Return last used Column name. 


Steps of Using Find Last Column

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Find Last Column Activity into Excel Scope Activity Body.
  3. Create Integer Variable to return last used column index in Column Index in Property Panel.
  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: Produce electronic books easily