MarketplaceStudioActivityBalaReva Easy Excel Activities

Create your first automation in just a few minutes.Try Studio Web

BalaReva Easy Excel Activities

BalaReva Easy Excel Activities

by Balamurugan Shanmugasundaram

6

Activity

Downloads

59.3k

back button
back button
carouselImage0
next button
next button

Summary

Summary

An activity library that makes Excel automation very easy.

Overview

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
  • FormulaArea
  1. Average Range
  2. Average Range
  3. CountA Range
  4. Count Range
  5. Max Range
  6. Min Range
  7. Sum Range
  • Freeze Columns
  1. Freeze Panes
  2. 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
  6. Image Resize
  • Outline
  1. Create Group
  2. Collapse All Group
  3. Ungroup
  • 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
  25. Get Range Style
  • 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
  7. SaveAs Sheet

Features

Features

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

Additional Information

Additional Information

Dependencies

Microsoft.Office.Interop.Excel DocumentFormat.OpenXml

Code Language

C#, Visual Basic

Runtime

Windows (.Net 5.0 or higher)