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
| Activity | Description |
|---|---|
| Open Spreadsheet | Opens the specified Excel spreadsheet and returns an instance handle of that Spreadsheet for other activities. |
| Add Sheet | Add a new Spreadsheet with the specified name under the specified workbook. |
| Clear Cells | Clears formats, contents, comments, and hyperlinks of specified cells |
| Close Spreadsheet | Closes the specified workbook |
| Copy Sheet | Copies the data from a source to a target sheet within a designated Excel workbook |
| Delete Column | Deletes the column specified by a zero-based index inside the specified Sheet under the specified workbook |
| Delete Row | Deletes the Row specified by a zero-based index inside the specified Sheet under the specified workbook |
| Delete Sheet | Delete the specified sheet under the specified workbook |
| Format Excel Cells | Applies specified formatting to the range of cells or comma-separated cells or single cell |
| Get First Empty Row/Column | Returns back the index of the first empty Row and column inside the specified Sheet under the specified workbook |
| Get First Empty Cell | Returns back the address of the first empty Cell in the specified row/column inside the specified Sheet under the specified workbook |
| Get Last Empty Cell | Returns 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/Column | Returns back the index of the last empty Row and column inside the specified Sheet under the specified workbook |
| Get Sheets | Returns a list of sheets in the specified Excel spreadsheet. |
| Merge Cells | Merges designated cell ranges within an Excel spreadsheet. |
| Lookup Range | Searches for the specified string in the given range and returns the list of cells that contain the search string. |
| Read Cell Formula | Returns back the formula applied to the specified Cell inside the specified Spreadsheet under the specified workbook |
| Read Cell | Returns back the value stored as part of the specified Cell inside the specified Spreadsheet under the specified workbook |
| Read Range | Reads 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 Sheets | Renames an existing Spreadsheet with the new name specified under the specified workbook |
| Set Active Cell | Sets the specified Cell as an active cell inside the specified Spreadsheet under the specified workbook |
| Set Active Sheet | Sets the specified Spreadsheet as an active Spreadsheet under the specified workbook |
| Sheet Exists | Specifies whether a Spreadsheet with the given name exists or not in a specified spreadsheet |
| Write Cell | Writes the specified value to the specified Cell inside the specified Spreadsheet under the specified workbook |
| Write Range | Imports the data from the specified DataTable inside the specified Spreadsheet starting from the specified Cell under the specified workbook |