MarketplaceListingsCustom ActivityBalaReva Easy Excel Activities

BalaReva Easy Excel Activities

Bronze Certified

Custom Activity

5 reviews

22.5k

BalaReva Easy Excel Activities

Bronze Certified

Custom Activity

5 reviews

22.5k


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. Table Info
  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
  6. Save As

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

C#, Visual Basic


Runtime

Windows Legacy (.Net Framework 4.6.1)


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
remove
remove filter
refresh
replace
row
rows
Select cell
sheet
size
style
tab color
table-name

Compatibility

Studio: 2019.0+


Dependencies

Microsoft.Office.Interop.Excel DocumentFormat.OpenXml


Similar Listings