iRobo.Activity.Save Workbook

Saves an opened WorkBook in an Excel file.


                       

     Note: 

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

                                                                                       

Properties

Input

  • CloseWorkBook - Close WorkBook after saving or not.  Its input is True/False arguments.
  • FileName -  Excel File path. (Mandatory)
  • SaveChanges - Save changes, only if it is not ReadOnly. Its input is True/False arguments.
  • SaveCopyAs - Save copy of opened WorkBook as a different Excel file.
  • WorkBook - Get Output WorkBook Variable from Excel file. (Mandatory)


Misc

  • DisplayName - Activity header name.
  • ReadPassword - Set password to read from Excel file .
  • WritePassword -  Set password to write in  Excel file.

Steps of Using Save Workbook Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Save WorkBook Activity to the Sequence.
  3. Click on button in Activity to select Excel File path to read file from.

     Note: 

         If the selected file is currently opened it will be closed. 

         Any changes on the workbook is saved only if the workbook is not read-only.
  1. Enter  WorkBook name of the opened Excel file in WorkBook field in Properties Panel.
  2. Click Save button from iRobo Studio Menu to save Workflow.
  3. Click Play button to start the automated process.





Created with the Personal Edition of HelpNDoc: Free EBook and documentation generator