UiPath Marketplace - BalaReva - Excel Automation for Enterprises

Help Marketplace
, ,
1

Dear all,

I have uploaded a new package in UiPath Marketplace. Here are the package’s activities.

Excel Application Scope

→ DropDown

  • DropDown List Values
  • DropDown Select
  • DropDown Selected Value

→ Shape

  • Add / New Shape
  • Add / New Shape At Cell
  • BringTo Forward And Backward
  • Delete All Shapes
  • Delete Shape
  • Duplicate Shape
  • Position At Cell Shape
  • Position Shape
  • Read Text All Shapes
  • Read Text Shape
  • Rotation Shape
  • Shape Properties
  • Shape Style
  • Size Shape
  • Write TextIn Shape

→ Slicer

  • Slicer Buttons
  • Slicer Clear
  • Slicer Item List
  • Slicer SelectedItem
  • Slicer SelectItem
  • Slicer Size
  • Slicer Style

→ TimeLine

  • TimeLine Clear
  • Timeline Get DateRange
  • TimeLine List
  • TimeLine Navigator
  • TimeLine Show

→ Chart

  • Bar Chart
  • Line Chart
  • Pie Chart

→ Chart Tools

  • Chart CopyTo Clipboard
  • Chart Delete
  • Chart Embed To PowerPoint
  • Chart Format
  • Chart Image Extract
  • Delete All Chart

→ Conditional Formatting

  • Above Average / Below Average
  • Clear All Rules
  • ColorScale2 Basic
  • ColorScale3 Basic
  • DataBar Basic
  • Duplicate Values
  • Highlight Cells
  • IconSets Basic
  • Top Bottom 10

→ Database

  • Execute DataTable
  • Execute NonQuery
  • Execute Scalar
  • Table Information

→ DataTool

  • Text To Column

→ Data Validation

  • Date Between Validation
  • Date Validation
  • Delete Validation
  • General Validation
  • General Validation[Between]
  • List Validation

→ Emty Rows

  • Delete Empty Rows
  • Find Empty Rows
  • Hide Unhide Empty Rows

→ Freeze Panes

  • Freeze Columns
  • Freeze Pane
  • Freeze Rows

→ Hide Unhide

  • Column Hide Unhide
  • List Hidden Columns
  • List Hidden Rows
  • Row Hide
  • WorkSheet Hide Unhide

→ Hyperlinks

  • Extract HyperLinks
  • Insert Hyperlink
  • Remove Hyperlink

→ Named Range

  • Create Name Range
  • Delete Name Range
  • List Name Range

→ No Parent Tool

  • Close All Excel
  • Create Workbook
  • Get Column Index
  • Get Column Name
  • Repair Work Book

→ Notes

  • Add Note
  • Delete Notes
  • Get Notes
  • Show / Hide Notes

To know more activities…

Thank you
Balamurugan.S

2 Likes
2

Hello @balupad14!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

3

@balupad14 - Your custom package is really helpful, but it increases the excel file size from a few KBs to a really larger size which it makes it difficult to handle/open the excel after the usage of your custome package.

1 Like