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
- Open iRobo Studio, and then open a new Workflow.
- Drag Excel Change Format Activity to the Sequence.
- Enter Excel file path including name and extension in FileName field in Property Panel.
- Enter Worksheet name in SheetName field in Property Panel.
- Create two Output Integer Variable for the last used row & column and add it to Output Fields in Property Panel.
- Click Save button from iRobo Studio Menu to save Workflow.
- Click Play button to start the automated process.
Created with the Personal Edition of HelpNDoc: Free help authoring tool