iRobo.Activity.Get Last Excel Row/Column

Gets last row/ column 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.


Output

  • LastColumn -  Get output number of last used column.
  • LastRow -  Get output number of last used row.


Steps of Using Get Last Excel Row/Column

  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 in SheetName field in Property Panel.
  5. Create two Output Integer Variable for the last used row & column and add it to Output Fields in Property Panel.
  6. Click Save button from iRobo Studio Menu to save Workflow.
  7. Click Play button to start the automated process.

Created with the Personal Edition of HelpNDoc: Free help authoring tool