Easy Excel Activities

Bronze Certified

Custom Activity

5 reviews

17.2k

Easy Excel Activities

Bronze Certified

Custom Activity

5 reviews

17.2k


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:

  • Main
  1. Excel Scope
  • Chart – Activities
  1. Chart CopyTo Clipboard
  2. Chart Delete
  3. Delete All Chart
  4. Chart Embed To PowerPoint
  5. Chart Format
  6. Chart Image Extract
  • EmptyRows
  1. Delete EmptyRows
  2. Find EmptyRows
  3. Hide Unhide EmptyRows
  • External
  1. Get hidden columns
  2. Get hidden rows
  • FreezePanes
  1. Freeze Columns
  2. Freeze Panes
  3. Freeze Rows
  • HyperLinks
  1. Get Hyperlink
  2. Insert Hyperlink
  3. Remove Hyperlink
  • Sheet Images
  1. CopyAs Picture
  2. Image Exists
  3. Image Extractor
  4. Image Delete
  5. Image Delete
  • Sheets
  1. Set Range Style
  2. Clear
  3. Column Move
  4. CopyTo Clipboard
  5. Delete All Charts
  6. Delete Columns
  7. Delete Rows
  8. Extract Graph Image
  9. Extract HyperLinks
  10. Fill Color
  11. Find
  12. Find & Replace
  13. Find LastColumn
  14. Find LastRow
  15. Copy Cells Format
  16. IsMerged Cell
  17. Page Setup
  18. Paste Clipboard
  19. Refresh All
  20. Remove Filter
  21. RemoveFilter NonTable
  22. Select Cell
  23. Set Border
  24. Sorting
  • Tables
  1. Delete Table
  2. Get Table Names
  3. Resize Table
  4. Table Exists
  • Tools
  1. Close All Excel
  2. Get Column Name
  3. Get Column Index
  • WorkBook
  1. ExportTo TextFile
  2. Combine / Append Sheet ByRow
  3. Move Sheet
  4. Show Visible / InVisible Sheet
  5. Tab Color

Benefits

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

Published: 27 Oct 2020 | Updated: 09 Jun 2021

Balamurugan Shanmugasundaram
Senior RPA Consultant

Lisbon, Portugal


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Framework


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

Studio: 2019.0 - 2021.4


Dependencies

Microsoft.Office.Interop.Excel DocumentFormat.OpenXml


Similar Listings