Easy Excel Activities

Custom Activity

Easy Excel Activities

Custom Activity

Summary: 

An activity library that makes Excel automation very easy

This package contains activities that will help automate your work with Excel. The below activities are available:
  • ExtractGraphImage
  • ExtractHyperLinks.
  • MoveSheet - Order or arrange sheets inside a workbook. [optional : Initial Sheet Name (":First" - Move to first sheet . :Last" - Move to last sheet) ]
  • ColumnMove
  • Paste From Clipboard
  • Copy to clipboard
  • Find
  • Find Replace
  • FindLastRow
  • FindLastColumn
  • CellFont
  • Get Table Names
  • TableExists
  • DeleteTable
  • Delete Column - It deletes contiguous Columns inside the excel sheet.
  • Delete Rows - It deletes contiguous Rows inside excel sheet.
  • Cell Font - It is an activity to change the Font Name, Size, Style, Color, Underline, Strikethrough, Script.
  • Refresh all - It refreshes the pivotal table.
  • SetBorder
  • GetHiddenColumns
  • GetHiddenRows
  • InsertHyperlink
  • GetHyperlink
  • RemoveHyperlink
  • IsMergedCell
  • Freeze Columns and Freeze Rows
  • Get Column Index
  • Get Column Name
  • Sorting
  • Remove / Clear filter
  • Remove / Clear NonTable filter
  • Format Painter
  • Extract Images
  • Delete Image,
  • Image Exists
  • Copy as picture
  • ChartImageExtract - Extract the charts as image with index
  • ChartFormat - Align the chart with top, left, height, and width.
  • ChartDelete - Delete the chart
  • ChartCopyToClipboard - copy the chart to clipboard
  • ChartEmbedToPowerPoint - Embed the excel chart into PowerPoint.
  • Tab Color - Change the tab color
  • Freeze Panes - To freeze the column and row
  • Select Cell - Select or activate the cell

Details

Benefits

The component is useful as it is a single activity that opens the Excel application and performs the activity flow for the process.

Compatibility

2019.4.1

Dependencies

Microsoft.Office.Interop.Excel
DocumentFormat.OpenXml

Licensing

By clicking download you agree to the following license.