iRobo.Activity.Hide Excel Worksheet

Hides a Worksheet in an Excel file.

     Note: 

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

                                                                                                               

Properties

Input

  • EditPasswod -  Enter Excel File password, to enable editing.
  • FileName -  Excel file path including name and extension. (Mandatory)
  • OpenPassword -   Enter Excel File password, to open.
  • SheetName -  Excel Sheet name of current Workbook. (Mandatory)


Misc                                                                                                        

  • DisplayName -  Activity header name.



Steps of Using Hide Excel Worksheet

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Excel Change Format Activity to the Sequence.
  3. Enter Excel file path including name and extension in FileName field in Property Panel.
  4. Enter Worksheet name to hide in SheetName field in Property Panel.
  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: Create iPhone web-based documentation