Skip to main content

Overview

Microsoft Excel is used by organizations to store, organize, compute, and manipulate data. Most of the Organizations have their day-to-day data departmental data stored as part of Excel Workbook. IntelliBuddies can enhance the efficiency of your organization users by automating most of the repeated data entry related tasks. IntelliBuddies offers wide range of activities to automate tasks in Excel and there-by providing deep integration with Microsoft Excel.

Activities#

ActivityDescription
Open SpreadsheetOpens the specified excel spreadsheet and returns back an instance handle of that spreadsheet to be used in other activities.
Get SheetsReturns back a list of sheets present in the specified excel spreadsheet.
Add SheetAdd a new sheet with the specified name under the specified workbook.
Rename SheetRenames an existing sheet with the new name specified under the specified workbook
Delete SheetDelete the specified sheet under the specified workbook
Set Active SheetSets the specified sheet as an active sheet under the specified workbook
Get First Empty RowReturns back the index of the first empty row in the specified column inside the specified sheet under the specified workbook
Get First Empty Row/ColumnReturns back the index of the first empty row and column inside the specified sheet under the specified workbook
Delete RowDeletes the row specified by a zero based index inside the specified sheet under the specified workbook
Delete ColumnDeletes the column specified by a zero based index inside the specified sheet under the specified workbook
Set Active CellSets the specified cell as an active cell inside the specified sheet under the specified workbook
Read CellReturns back the value stored as part of the specified cell inside the specified sheet under the specified workbook
Read RangeReads the data from the specified cell range inside the specified sheet under the specified workbook. Returns back the read data in the for of DataTable.
Read Cell FormulaReturns back the formula applied to the specified cell inside the specified sheet under the specified workbook
Write CellWrites the specified value to the specified cell inside the specified sheet under the specified workbook
Write RangeImports the data from the specified DataTable inside the specified sheet starting from the specified cell under the specified workbook
Lookup RangeSearches for the specified text inside the specified cell range and returns back the address of the first cell within the range where the text is found
Close SpreadsheetCloses the specified workbook