Skip to main content

Overview

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

Activities

ActivityDescription
Open SpreadsheetOpens the specified Excel spreadsheet and returns an instance handle of that spreadsheet for other activities.
Add SheetAdd a new Spreadsheet with the specified name under the specified workbook.
Clear CellsClears formats, contents, comments, and hyperlinks of specified cells
Close SpreadsheetCloses the specified workbook
Copy SheetCopies the data from a source to a target sheet within a designated Excel workbook
Delete ColumnDeletes the column specified by a zero-based index 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 SheetDelete the specified sheet under the specified workbook
Format Excel CellsApplies specified formatting to the range of cells or comma-separated cells or single cell
Get First Empty Row/ColumnReturns back the index of the first empty row and column inside the specified sheet under the specified workbook
Get First Empty CellReturns back the address of the first empty cell in the specified row/column inside the specified sheet under the specified workbook
Get Last Empty CellReturns back the address of the last empty cell in the specified row/column inside the specified sheet under the specified workbook
Get Last Empty Row/ColumnReturns back the index of the last empty row and column inside the specified sheet under the specified workbook
Get SheetsReturns a list of sheets in the specified Excel spreadsheet.
Lookup RangeSearches for the specified string in the given range and returns the list of cells which contains the search string.
Read Cell FormulaReturns back the formula applied to the specified cell inside the specified Spreadsheet under the specified workbook
Read CellReturns back the value stored as part of the specified cell inside the specified Spreadsheet under the specified workbook
Read RangeReads the data from the specified cell range inside the specified Spreadsheet under the specified workbook. Returns the read data in the form of DataTable.
Rename SheetsRenames an existing Spreadsheet with the new name specified under the specified workbook
Set Active CellSets the specified cell as an active cell inside the specified Spreadsheet under the specified workbook
Set Active SheetSets the specified Spreadsheet as an active Spreadsheet under the specified workbook
Sheet ExistsSpecifies whether a Spreadsheet with the given name exists or not in a specified spreadsheet
Write CellWrites the specified value to the specified cell inside the specified Spreadsheet under the specified workbook
Write RangeImports the data from the specified DataTable inside the specified Spreadsheet starting from the specified cell under the specified workbook