Easy Excel Activities

Bronze Certified

Custom Activity

4 reviews

8.7k

Easy Excel Activities

Bronze Certified

Custom Activity

4 reviews

8.7k


Summary

An activity library that makes Excel automation very easy

carouselImage0

Overview

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.
  • Set Range Style - 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

Benefits


Published: Oct 27, 2020 | Updated: Dec 18, 2020

Balamurugan Shanmugasundaram
Senior RPA Consultant

Lisbon, Portugal


License

MIT


Code Language

C#, Visual Basic


Tags


Compatibility

2019.4.1


Dependencies

Microsoft.Office.Interop.Excel DocumentFormat.OpenXml