Excel

Automate any Excel related activity
Launch Launches Excel with a blank document
Excel.Launch Visible:True LoadAddInsAndMacros:False Instance=> ExcelInstance
LaunchAndOpen Launches Excel and opens a document
Excel.LaunchAndOpen Path:  Visible:True Password:'' ReadOnly:False LoadAddInsAndMacros:False Instance=> ExcelInstance
Attach Attaches to an Excel document that's already open
Excel.Attach DocumentName:  Instance=> ExcelInstance
Read Reads the values of the currently selected cells of an Excel instance
Excel.Read Instance:  ReadAsText:False FirstLineIsHeader:False Value=> Value
ReadCell Reads the value of a single cell of an Excel instance
Excel.ReadCell Instance:  StartColumn:  StartRow:  ReadAsText:False Value=> Value
ReadCells Reads 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 Saves an Excel document
Excel.Save Instance: 
SaveAs Saves an Excel document specifying its name and format
Excel.SaveAs Instance:  DocumentFormat:Excel.ExcelFormat.FromExtension DocumentPath: 
Write Writes some value at the currently active cell of an Excel instance
Excel.Write Instance:  Value: 
WriteCell Writes some value at the specified cell of an Excel instance
Excel.WriteCell Instance:  Value:  Column:  Row: 
Close Closes an Excel instance
Excel.Close Instance: 
CloseAndSave Closes and saves an Excel instance
Excel.CloseAndSave Instance: 
CloseAndSaveAs Closes and saves an Excel instance with a specified format
Excel.CloseAndSaveAs Instance:  DocumentFormat:Excel.ExcelFormat.FromExtension DocumentPath: 
ActivateWorksheetByIndex Activates a specific worksheet of an Excel instance using its index
Excel.ActivateWorksheetByIndex Instance:  Index: 
ActivateWorksheetByName Activates a specific worksheet of an Excel instance using its name
Excel.ActivateWorksheetByName Instance:  Name: 
AddWorksheet Adds a new worksheet to the document of an Excel instance
Excel.AddWorksheet Instance:  Name:  WorksheetPosition:Excel.WorksheetPosition.First
GetFirstFreeColumnRow 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
Excel.GetFirstFreeColumnRow Instance:  FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow

Advanced

Advanced Excel automation actions

RunMacro Runs a specified macro on the document of an Excel instance
Excel.Advanced.RunMacro Instance:  Macro: 
GetActiveWorksheet Retrieves an Excel document's active worksheet
Excel.Advanced.GetActiveWorksheet Instance:  Name=> SheetName Index=> SheetIndex
GetAllWorksheets Retrieves all worksheet names of an Excel document
Excel.Advanced.GetAllWorksheets Instance:  Worksheets=> Worksheets
DeleteWorksheetByIndex Deletes a specific worksheet from an Excel instance specified by its index
Excel.Advanced.DeleteWorksheetByIndex Instance:  Index: 
DeleteWorksheetByName Deletes a specific worksheet from an Excel instance specified by its name
Excel.Advanced.DeleteWorksheetByName Instance:  Name: 
RenameWorksheetWithIndex Renames a specific worksheet of an Excel instance specified by its index
Excel.Advanced.RenameWorksheetWithIndex Instance:  Index:  NewName: 
RenameWorksheetWithName Renames a specific worksheet of an Excel instance specified by its name
Excel.Advanced.RenameWorksheetWithName Instance:  Name:  NewName: 
ActivateCell Activate a cell in the active worksheet of a previously launched Excel Instance, given column and row
Excel.Advanced.ActivateCell Instance:  Column:  Row: 
ActivateCellRelativeTo Activate a cell in the active worksheet of a previously launched Excel Instance, given column, row and offset
Excel.Advanced.ActivateCellRelativeTo Instance:  Direction:Excel.TwoDimensionalDirection.Left OffsetFromActiveCell: 
SelectCells Selects a range of cells in the active worksheet of an Excel instance
Excel.Advanced.SelectCells Instance:  StartColumn:  StartRow:  EndColumn:  EndRow: 
SelectCellsRelativeTo Selects a range of cells in the active worksheet of an Excel instance
Excel.Advanced.SelectCellsRelativeTo Instance:  HorizontalDirection:Excel.HorizontalDirection.Left OffsetX:  VerticalDirection:Excel.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.Advanced.GetSelectedCellRange Instance:  FirstColumnIndex=> FirstColumnIndex FirstRowIndex=> FirstRowIndex LastColumnIndex=> LastColumnIndex LastRowIndex=> LastRowIndex
Copy Copies the currently selected cells of the active worksheet
Excel.Advanced.Copy Instance: 
CopyCell Copies a single cell from the active worksheet
Excel.Advanced.CopyCell Instance:  StartColumn:  StartRow: 
CopyCells Copies a range of cells from the active worksheet
Excel.Advanced.CopyCells Instance:  StartColumn:  StartRow:  EndColumn:  EndRow: 
Paste Pastes a range of cells to the currently active cell of the active worksheet of an Excel instance
Excel.Advanced.Paste Instance: 
PasteAt Pastes a range of cells to the specified position of the active worksheet of an Excel instance
Excel.Advanced.PasteAt Instance:  Column:  Row: 
InsertRow Inserts a row above a selected row of an Excel instance
Excel.Advanced.InsertRow Instance:  Index: 
DeleteRow Deletes a selected row from an Excel instance
Excel.Advanced.DeleteRow Instance:  Index: 
InsertColumn Inserts a column to the left of a selected column of an Excel instance
Excel.Advanced.InsertColumn Instance:  Column: 
DeleteColumn Deletes a selected column from an Excel instance
Excel.Advanced.DeleteColumn Instance:  Column: 
GetFirstFreeRowOnColumn Retrieve the first free row, given the column of the active worksheet
Excel.Advanced.GetFirstFreeRowOnColumn Instance:  Column:  FirstFreeRowOnColumn=> FirstFreeRowOnColumn