Excel

A group of Actions that will automate any Excel related activity
Launch Launch Excel with a blank document

Excel.Launch Visible:True LoadAddInsAndMacros:False Instance=> ExcelInstance
LaunchAndOpen Launch Excel and open a document

Excel.LaunchAndOpen Path:  Visible:True Password:'' ReadOnly:False LoadAddInsAndMacros:False Instance=> ExcelInstance
Attach Attach to an Excel Document that's already open

Excel.Attach DocumentName:  Instance=> ExcelInstance
Read Read the values of the currently selected cells of an Excel Instance

Excel.Read Instance:  ReadAsText:False FirstLineIsHeader:False Value=> Value
ReadCell Read the value of a single cell of an Excel Instance

Excel.ReadCell Instance:  StartColumn:  StartRow:  ReadAsText:False Value=> Value
ReadCells Read the values of a range of cells of an Excel Instance

Excel.ReadCells Instance:  StartColumn:  StartRow:  EndColumn:  EndRow:  ReadAsText:False FirstLineIsHeader:False Value=> Value
Save Save an Excel Document

Excel.Save Instance:
SaveAs Save an Excel Document specifying its name and format

Excel.SaveAs Instance:  DocumentFormat:ExcelFormat.FromExtension DocumentPath:
Write Write some value at the currently active cell of an Excel Instance

Excel.Write Instance:  Value: 
WriteCell Write some value at the specified cell of an Excel Instance

Excel.WriteCell Instance:  Value:  Column:  Row:
Close Close an Excel Instance

Excel.Close Instance: 
CloseAndSave Close and save an Excel Instance

Excel.CloseAndSave Instance:
CloseAndSaveAs Close and save an Excel Instance with a specified format

Excel.CloseAndSaveAs Instance:  DocumentFormat:ExcelFormat.FromExtension DocumentPath:
ActivateWorksheetByIndex Activate a specific worksheet of an Excel Instance using its index

Excel.ActivateWorksheetByIndex Instance:  Index:
ActivateWorksheetByName Activate a specific worksheet of an Excel Instance using its name

Excel.ActivateWorksheetByName Instance:  Name:
AddWorksheet Add a new worksheet to the document of a previously launched Excel Instance

Excel.AddWorksheet Instance:  Name:  WorksheetPosition:WorksheetPosition.First
GetFirstFreeColumnRow Retrieve 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

Excel.GetFirstFreeColumnRow Instance:  FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow
RunMacro Run a specified macro on the document of a previously launched Excel Instance

Excel.RunMacro Instance:  Macro:
GetActiveWorksheet Retrieve an Excel document's active worksheet

Excel.GetActiveWorksheet Instance:  Name=> SheetName Index=> SheetIndex
GetAllWorksheets Retrieve all worksheet names of an Excel document

Excel.GetAllWorksheets Instance:  Worksheets=> Worksheets
DeleteWorksheetByIndex Delete a specific worksheet from a previously launched Excel Instance specified by its index

Excel.DeleteWorksheetByIndex Instance:  Index:
DeleteWorksheetByName Delete a specific worksheet from a previously launched Excel Instance specified by its name

Excel.DeleteWorksheetByName Instance:  Name:
RenameWorksheetWithIndex Renames a specific worksheet of an Excel Instance specified by its index

Excel.RenameWorksheetWithIndex Instance:  Index:  NewName:
RenameWorksheetWithName Renames a specific worksheet of an Excel Instance specified by its name

Excel.RenameWorksheetWithName Instance:  Name:  NewName:
ActivateCell Activate a cell in the active worksheet of a previously launched Excel Instance, given column and row

Excel.ActivateCell Instance:  Column:  Row:
ActivateCellRelativeTo Activate a cell in the active worksheet of a previously launched Excel Instance, given column, row and offset

Excel.ActivateCellRelativeTo Instance:  Direction:TwoDimensionalDirection.Left OffsetFromActiveCell:
SelectCells Select a range of cells in the active worksheet of an Excel Instance

Excel.SelectCells Instance:  StartColumn:  StartRow:  EndColumn:  EndRow:
SelectCellsRelativeTo Select a range of cells in the active worksheet of an Excel Instance

Excel.SelectCellsRelativeTo Instance:  HorizontalDirection:HorizontalDirection.Left OffsetX:  VerticalDirection:VerticalDirection.Above OffsetY:
GetSelectedCellRange Retrieve the selected range of cells in a structure consisting of first column, first row, last column and last row

Excel.GetSelectedCellRange Instance:  FirstColumnIndex=> FirstColumnIndex FirstRowIndex=> FirstRowIndex LastColumnIndex=> LastColumnIndex LastRowIndex=> LastRowIndex
Copy Copy the currently selected cells of the active worksheet

Excel.Copy Instance:
CopyCell Copy a single cell from the active worksheet

Excel.CopyCell Instance:  StartColumn:  StartRow:
CopyCells Copy a range of cells from the active worksheet

Excel.CopyCells Instance:  StartColumn:  StartRow:  EndColumn:  EndRow:
Paste Paste a range of cells to the currently active cell of the active worksheet of an Excel Instance

Excel.Paste Instance:
PasteAt Paste a range of cells to the specified position of the active worksheet of an Excel Instance

Excel.PasteAt Instance:  Column:  Row:
InsertRow Insert a row above a selected row of a previously launched Excel Instance

Excel.InsertRow Instance:  Index:
DeleteRow Delete a selected row from a previously launched Excel Instance

Excel.DeleteRow Instance:  Index:
InsertColumn Insert a column to the left of a selected column of a previously launched Excel Instance

Excel.InsertColumn Instance:  Column:
DeleteColumn Delete a selected column from a previously launched Excel Instance

Excel.DeleteColumn Instance:  Column:
GetFirstFreeRowOnColumn Retrieve the first free row, given the column of the active worksheet

Excel.GetFirstFreeRowOnColumn Instance:  Column:  FirstFreeRowOnColumn=> FirstFreeRowOnColumn