iRobo.Activity.Read Excel Cell

Reads specific cell in an Excel file.


       

     Note: 

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

                                                                                                       

Properties

Input

  • Cell - Cell number includes "row name" & column number. (Mandatory)


Misc

  • ArgumentType - Select value type to read.
  • DisplayName - Activity header name.
  • FileName -   Excel File path. (Mandatory)
  • Result -   Output Variable to store result.
  • Visible -  Visible cell or not. Its input is True/False arguments. 
  • WorkBook - Get Output WorkBook Variable of Excel file. 
  • Worksheet - Specify Excel Sheet to read from.


Output

  • Formula - Insert a formula to calculate cell value. 
  • Range - Get Output range of cells.



Steps of Using Read Excel Cell Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Read Excel Cell Activity to the Sequence.
  3. Click on button in Activity to select Excel File path to read file from, as shown in the image below.

  1. Enter Cellfield  ("Row name" & column number ) to get the number of cell in the Properties Panel, as shown in the image below .

     

  1. Select cell ArgumentType to read. For example: String.
  2. Set an Output Variable to Formula in Properties Panel, then click Ctrl+K to instantly create the variable.
  3. Drag MessageBox Activity to the Sequence and set the input  Message field to the Output Variable of Formula field.
  4. Click Save button from iRobo Studio Menu to save Workflow.
  5. Click Play button to start the automated process.
  6. Message box appears display the output Formula field in Read Excel Cell Activity.




Created with the Personal Edition of HelpNDoc: Free PDF documentation generator