iRobo.Activity.Show Excel Worksheet

Shows a hidden Worksheet of 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 Show 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 hidden Sheet name to show in the current Workbook 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: Write eBooks for the Kindle