Use Of Ms Excel

Posted on  by 



  1. Use Of Ms Excel In Teaching Learning Process
  2. Use Of Ms Excel In Business
-->

Automate any Excel related activity

If you want to use an Excel template (e.g., a budget planner template), scroll down until you find the template you want to use and then click it once to open its window. If you just want to open a new blank Excel document, click the Blank option in the upper-left side of the page and then skip the next step. Specify whether to open a New Excel document, or an existing one: Document path: No: File: The full path of the existing Excel document to open: Make instance visible: N/A: Boolean value: True: Specify whether to make the Excel window visible or hide it: Password: Yes: Encrypted value: The password on the Excel document, if it is password.

Use Of Ms Excel
Run Excel Macro
Get active Excel worksheet
Get all Excel worksheets
Delete Excel worksheet
Rename Excel worksheet
Activate Cell in Excel Worksheet
Select cells in Excel worksheet
Get selected cell range from Excel worksheet
Copy cells from Excel worksheet
Paste cells to Excel worksheet
Insert row to Excel worksheet
Delete row from Excel worksheet
Insert column to Excel worksheet
Delete column from Excel worksheet
Get first free row on column from Excel worksheet
Launch Excel
Attach to running Excel
Read from Excel worksheet
Save Excel
Write to Excel worksheet
Close Excel
Set active Excel worksheet
Add new worksheet
Get first free column/row from Excel worksheet

Advanced

Advanced Excel automation actions

Run Excel Macro

Runs a specified macro on the document of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
MacroNoText valueThe macro to run. The text should consist of the name of the macro, followed by any arguments (optional), all separated by semicolons
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to run macroIndicates a problem running the specified macro

Get active Excel worksheet

Retrieves an Excel document's active worksheet

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Variables Produced
ArgumentTypeDescription
SheetNameText valueThe name of the active worksheet
SheetIndexNumeric valueThe index of the active worksheet
Exceptions
ExceptionDescription
Failed to retrieve active worksheetIndicates a problem retrieving the active worksheet

Get all Excel worksheets

Retrieves all worksheet names of an Excel document

Input Parameters

Use Of Ms Excel In Teaching Learning Process

ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance. This variable must have been previously specified in a Launch Excel action
Variables Produced
ArgumentTypeDescription
SheetNamesList of Text valuesThe names of all worksheets
Exceptions
ExceptionDescription
Failed to retrieve all worksheet namesIndicates a problem retrieving the names of the Excel worksheet

Delete Excel worksheet

Deletes a specific worksheet from an Excel instance

Input Parameters
Excel
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Delete worksheet withN/AIndex, NameNameWhether to find the worksheet by name or index
Worksheet indexNoNumeric valueThe Index number of the worksheet to delete. The numbering starts from 1, meaning that the index of the fist worksheet is 1, the second one is 2 etc.
Worksheet nameNoText valueThe name of the worksheet to delete
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find worksheetIndicates that a worksheet with the specified name could not be found
Failed to delete worksheetIndicates a problem deleting the specified worksheet

Rename Excel worksheet

Renames a specific worksheet of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance. This variable must have been previously specified in a Launch Excel action
Rename worksheet withN/AIndex, NameNameSpecify whether to find the worksheet by name or index
Worksheet indexNoNumeric valueThe index of the worksheet to rename. The numbering starts from 1, meaning that the index of the fist worksheet is 1, of the second is 2 etc.
Worksheet nameNoText valueThe name of the worksheet to rename
Worksheet new nameNoText valueThe new name of the worksheet
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find worksheetIndicates that a worksheet with the specified name could not be found
Failed to rename worksheetIndicates a problem renaming the specified worksheet

Activate Cell in Excel Worksheet

Activate a cell in the active worksheet of an Excel instance, by providing column, row and offset

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance to work with. This variable must have been previously specified in a Launch Excel action
ActivateN/AAbsolutely specified cell, Relatively specified cellAbsolutely specified cellSelect whether to specify the cell to activate absolutely, or relatively, by using an offset distance being the number of cells between the currently activated reference cell and the actual cell activate
ColumnNoText valueThe numeric value or letter of the cell column
DirectionN/ALeft, Right, Above, BelowLeftSelect offset direction. Select where to look for the cell to activate based on the position of the currently active cell
Offset from active cellNoNumeric valueThe distance in cells between the currently active cell and the desired cell. The numbering starts from 0
RowNoNumeric valueThe numeric value of the cell row. The numbering starts from 1
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to activate cellIndicates a problem activating an Excel cell

Select cells in Excel worksheet

Selects a range of cells in the active worksheet of an Excel instance

Input Parameters
Use of ms excel in business
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
SelectN/AAbsolutely specified cell, Relatively specified cellAbsolutely specified cellSpecify whether to select an explicitly specified range of cells or a range of cells relatively to the currently active cell
X Axis DirectionN/ALeft, RightLeftThe X-axis offset direction. Where to look along the horizontal axis, based on currently activated cell's position
Start columnNoText valueThe index or letter of the first column
X OffsetNoNumeric valueThe X-axis offset
Start rowNoNumeric valueThe first row number. The numbering starts from 1
End columnNoText valueThe index or letter of the last column
Y Axis DirectionN/AAbove, BelowAboveThe Y-axis offset direction. Where to look along the vertical axis, based on the position of the currently active cell
End rowNoNumeric valueThe last row number. The numbering starts from 1
Y OffsetNoNumeric valueThe Y-axis offset
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to select cellsIndicates a problem selecting the specified cells

Get selected cell range from Excel worksheet

Retrieve the selected range of cells in a structure consisting of first column, first row, last column and last row

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Variables Produced
ArgumentTypeDescription
FirstColumnIndexNumeric valueThe numeric value of the range's first column
FirstRowIndexNumeric valueThe numeric value of the range's first row
LastColumnIndexNumeric valueThe numeric value of the range's last column
LastRowIndexNumeric valueThe numeric value of the range's last row
Exceptions
ExceptionDescription
Failed to retrieve the selected range of cellsIndicates a problem retrieving the selected range of cells

Copy cells from Excel worksheet

Copies a range of cells from the active worksheet of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Copy modeN/ASingle Cell's Values, Values from a Range of Cells, Values from SelectionSingle Cell's ValuesSpecify whether to copy a single cell, a range of cells or the current selection of cells
Start columnNoText valueThe index or letter of the first column
Start rowNoNumeric valueThe index of the first row
End columnNoText valueThe index or letter of the last column
End rowNoNumeric valueThe index of the last row
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to copy cellsIndicates a problem copying the cells from the Excel document

Paste cells to Excel worksheet

Pastes a range of cells to the active worksheet of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance. This variable must have been previously specified in a Launch Excel action
Paste modeN/AOn specified cell, On currently active cellOn specified cellSpecify whether to paste on a specified cell or the currently active cell
ColumnNoText valueThe index or letter of the cell column
RowNoNumeric valueThe row number
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to paste cellsIndicates a problem pasting the specified cells

Insert row to Excel worksheet

Inserts a row above a selected row of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Row indexNoNumeric valueThe index of the row to add a new row above. The numbering starts from 1
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find rowIndicates that a row with the specified index could not be found
Failed to insert rowIndicates a problem inserting a row at the specified Excel instance

Delete row from Excel worksheet

Deletes a selected row from an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance. This variable must have been previously specified in a Launch Excel action
Delete rowNoNumeric valueThe Index number of the row to delete. The numbering starts from 1
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find rowIndicates that a row with the specified index could not be found
Failed to delete rowIndicates a problem deleting the specified row

Insert column to Excel worksheet

Inserts a column to the left of a selected column of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
ColumnNoText valueThe column's index number or letter. A new column will appear on the left side of the column indicated
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find columnIndicates that a column with the specified name could not be found
Failed to insert columnIndicates a problem inserting a column at the specified Excel instance

Delete column from Excel worksheet

Deletes a selected column from an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Delete columnNoText valueThe index number or letter of the column to delete
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find columnIndicates that a column with the specified name could not be found
Failed to delete columnIndicates a problem deleting the specified column

Get first free row on column from Excel worksheet

Retrieve the first free row, given the column of the active worksheet

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance. This variable must have been previously specified in a Launch Excel action
ColumnNoText valueThe index or letter that identifies the column. Column numbering starts from index 1
Variables Produced
ArgumentTypeDescription
FirstFreeRowOnColumnNumeric valueThe numeric value of the given column's first fully empty row
Exceptions
ExceptionDescription
Failed to retrieve first free rowIndicates a problem retrieving the first free row of an Excel instance

Launch Excel

Launches a new Excel instance or opens an Excel document

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Launch ExcelN/Awith a blank document, and open the following documentwith a blank documentSpecify whether to open a New Excel document, or an existing one
Document pathNoFileThe full path of the existing Excel document to open
Make instance visibleN/ABoolean valueTrueSpecify whether to make the Excel window visible or hide it
PasswordYesEncrypted valueThe password on the Excel document, if it is password protected
Open as ReadOnlyN/ABoolean valueFalseSpecify whether to open the stored document in read-only mode or not
Load add-ins and macrosN/ABoolean valueFalseSpecify whether to load add-ins and macros into the new Excel instance
Variables Produced
ArgumentTypeDescription
ExcelInstanceExcel instanceThe specific Excel instance for use with later Excel actions. This allows the user to specify which of possibly several Excel spreadsheets to access

Use Of Ms Excel In Business

Exceptions
ExceptionDescription
Failed to launch ExcelIndicates a problem launching an Excel instance
Failed to open Excel documentIndicates a problem opening the specified Excel document

Attach to running Excel

Use Of Ms Excel

Attaches to an Excel document that's already open

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Document nameNoFileThe name or the path of the Excel document to attach to
Variables Produced
ArgumentTypeDescription
ExcelInstanceExcel instanceThe Excel instance this action has attached to for use with later Excel actions
Exceptions
ExceptionDescription
Specified Excel document not foundIndicates that the specified Excel document could not be found
Failed to attach to Excel documentIndicates a problem attaching to the Excel document

Read from Excel worksheet

Reads the value of a cell or a range of cells from the active worksheet of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
RetrieveN/ASingle Cell's Values, Values from a Range of Cells, Values from SelectionSingle Cell's ValuesWhether to retrieve the value of a single cell or a table from a range of cells
Start columnNoText valueThe cell column (single cell's value) or first column as a numeric value or a letter
Start rowNoNumeric valueThe cell row (single cell's Value) or first row number
End columnNoText valueThe last column as a numeric value or a letter
End rowNoNumeric valueThe last row number
Get Cell Contents as TextN/ABoolean valueFalseSpecify whether to retrieve the content of the cell(s) purely as text or as the closest matching type such as Date Time for dates, Numeric for numbers and so on
First line of range contains column namesN/ABoolean valueFalseSpecify whether to consider the first row as column names. In this case, the names won't be read as data into the table and later actions can search the data by column names
Variables Produced
ArgumentTypeDescription
ExcelDataGeneral valueThe value of the single cell
ExcelDataDatatableThe value of the range of cells as a DataTable
Exceptions
ExceptionDescription
Failed to read cell value(s)Indicates a problem reading the value(s) of the specified Excel cell(s)

Save Excel

Saves a previously launched Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to save. This variable must have been previously specified in a Launch Excel action
Save modeN/ASave document, Save document asSave documentHow to save the document of this instance
Document formatN/ADefault (From Extension), Excel Workbook (.xlsx), Excel Workbook Macro Enabled (.xlsm), Excel 97-2003 Workbook (.xls), Web Page (.htm, .html), Excel Template (.xltx), Excel Template Macro Enabled (.xltm), Excel 97-2003 Template (.xlt), Text (.txt), Unicode Text (.txt), Text Macintosh (.txt), Text DOS (.txt), XML Spreadsheet (.xml), Excel 95 (.xls), CSV (.csv), DIF (.dif), SYLK (.slk), Excel Add-In (.xlam), Excel 97-2003 Add-In (.xla), Strict Open XML Workbook (.xlsx), OpenDocument Spreadsheet (.ods)Default (From Extension)The format to save the document as
Document pathNoFileThe full path to save the document as
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to save Excel documentIndicates a problem saving the Excel document

Write to Excel worksheet

Writes a value into a cell or a range of cells of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to work with. This variable must have been previously specified in a Launch Excel action
Value to writeNoGeneral valueEnter the text, number or variable to insert. If the variable contains a table, it will fill in cells to the right and below writing over other cell data if need be and a list will fill in cells below
Write modeN/AOn specified cell, On currently active cellOn specified cellWhether to write into a specified cell or the currently active cell
ColumnNoText valueThe column number or letter for the cell to write to
RowNoNumeric valueThe row of the cell to write to. The numbering starts from 1, meaning that the index of the fist worksheet is 1, of the second is 2 etc.
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to write value to ExcelIndicates a problem writing the specified value to the Excel instance

Close Excel

Closes an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceThe Excel instance to close. This variable must have been previously specified in a Launch Excel action
Before closing ExcelN/ADo not save document, Save document, Save document asDo not save documentWhether and how to save the document of this instance before closing that instance
Document formatN/ADefault (From Extension), Excel Workbook (.xlsx), Excel Workbook Macro Enabled (.xlsm), Excel 97-2003 Workbook (.xls), Web Page (.htm, .html), Excel Template (.xltx), Excel Template Macro Enabled (.xltm), Excel 97-2003 Template (.xlt), Text (.txt), Unicode Text (.txt), Text Macintosh (.txt), Text DOS (.txt), XML Spreadsheet (.xml), Excel 95 (.xls), CSV (.csv), DIF (.dif), SYLK (.slk), Excel Add-In (.xlam), Excel 97-2003 Add-In (.xla), Strict Open XML Workbook (.xlsx), OpenDocument Spreadsheet (.ods)Default (From Extension)The format of the document
Document pathNoFileThe full path of the document
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Failed to save Excel documentIndicates a problem saving the Excel document
Failed to close Excel instanceIndicates a problem closing the Excel instance

Set active Excel worksheet

Activates a specific worksheet of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance. This variable must have been previously specified in a Launch Excel action
Activate worksheet withN/AIndex, NameNameSpecify whether to find the worksheet by name or index
Worksheet indexNoNumeric valueThe index number of the worksheet to activate. The numbering starts from 1, meaning that the index of the fist worksheet is 1, of the second is 2, etc.
Worksheet nameNoText valueThe name of the worksheet to activate
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
Can't find worksheetIndicates that a worksheet with the specified name could not be found
Failed to activate worksheetIndicates a problem activating the specified worksheet

Add new worksheet

Adds a new worksheet to the document of an Excel instance

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify the Excel instance. This variable must have been previously specified in a Launch Excel action
New worksheet nameNoText valueSpecify the name of the new worksheet
Add worksheet asN/AFirst worksheet, Last worksheetFirst worksheetSpecify whether the new Excel worksheet will be added before or after the existing worksheets
Variables Produced
  • This action doesn't produce any variables
Exceptions
ExceptionDescription
A worksheet with the same name already existsIndicates that the worksheet could not be added because a worksheet with the same name already exists
Failed to add worksheetIndicates a problem adding the worksheet

Get first free column/row from Excel worksheet

Retrieves the first free column and/or row of the active worksheet. This is useful for adding new data into a worksheet that already has data in it

Input Parameters
ArgumentOptionalAcceptsDefault ValueDescription
Excel instanceNoExcel instanceSpecify The Excel instance. This variable must have been previously specified in a Launch Excel action
Variables Produced
ArgumentTypeDescription
FirstFreeColumnNumeric valueThe numeric value of the first fully empty column. For example, if column F is the first empty column, it will be stored as '6'
FirstFreeRowNumeric valueThe numeric value of the first fully empty row. For example, if row 7 is the first empty row, it will be stored as '7'
Exceptions
ExceptionDescription
Failed to retrieve first free column/rowIndicates a problem retrieving the first free column/row of an Excel instance

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).





Coments are closed