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 ToClipboard
  • Find
  • FindReplace
  • FindLastRow
  • FindLastColumn
  • CellFont
  • Get Table Names
  • TableExists
  • DeleteTable
  • Delete Column - It deletes contiguous Columns inside 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,Strike through,Script.
  • Refresh all - It refresh the pivotal table.
  • SetBorder
  • GetHiddenColumns
  • GetHiddenRows
  • InsertHyperlink
  • GetHyperlink
  • RemoveHyperlink
  • IsMergedCell
  • Freeze Columns and Freeze Rows
  • Get Column Index
  • Get Column Name
  • Sorting

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.