Easy Excel Activities

Bronze Certified

Custom Activity

5 reviews

11k

Easy Excel Activities

Bronze Certified

Custom Activity

5 reviews

11k


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: 2020-10-27T14:15:10+00:00 | Updated: 2020-12-18T09:04:53+00:00

Balamurugan Shanmugasundaram
Senior RPA Consultant

Lisbon, Portugal


License

MIT


Code Language

C#, Visual Basic


Tags

balareva
border
cell
change
chart
clipboard
color
column
copy-as-picture
copy-column
delete
easy
embed chart
embed powerpoint
extract
find
font
Format Painter
freeze panes
get
graph
hyperlink
insert
last
merged
move
move-column
orange
order
paste
pivot-table
refresh
remove
remove filter
replace
row
rows
Select cell
sheet
size
style
tab color
table-name

Compatibility

2019.4.1


Dependencies

Microsoft.Office.Interop.Excel DocumentFormat.OpenXml


Similar Listings