BalaReva.Excel.Activities 17.0.0

1.Pie,Column,Line,Bar charts for the excel data.
2.Rename Work Sheet.
3.Column Hide/Unhide activity
4.Row Hide/Unhide activity
5.Copy Data activity
6.Delete Data activity
7.Clipboard To Datatable activity
8.Merge Cells,UnMerge Cells.
9.Excel to Access export option
10. Comment Activities(Add,Get,Delete,Show Hide)
11.Add Sheet and Delete Sheet
12.Sheets- Copy to (Workbook,File),Hide Unhide,Protect Unprotect,Create Workbook
13.Insert Image,Insert Table Format,Set Password
14. Get Sheets Name
15-HyperLink Remove
16-Find and Replace
17-Hyperlink Add
18-Remove Duplicates

Installation

UiPath Studio

Package Manager -> Right Click -> Configure Sources -> Add https://gallery.uipath.com/api/v2.

1.It has an custom components to generate the Pie,Column,Line,Bar charts for the excel data.

It has provision to copy the charts as image by using Image Copy property.
2.New Activity to rename the workbook sheet name Rename Work Sheet.

3.Column Hide/Unhide activity.

4.Row Hide/Unhide activity.

5.Copy Data activity.

6.Delete Data activity.

7.Clipboard To Datatable activity.

8.Merge Cells activity.

9.Unmerge cells activity.

10.Excel Export to Access activity.

11.Comment Activities (Add,Delete,Get,ShowHide).

12.Add Sheet and Delete Sheet Activities

13.Copy to WorkBook Activity

14.Copy to File Activity

15.Hide Unhide sheet Activity

16.Protect Unprotect sheet Activity

17.Create Workbook Activity

18.Insert Image Activity

19.Insert Table Format Activity

20.Set Password Activity

21.Get Sheets Name Activity

22.HyperLink Remove Activity

23.Find Replace Activity

24.Hyperlink Add Activity

25.Remove Duplicates Activity

To get more detail . Please take look this url

https://forum.uipath.com/t/balareva-excel-activities/38367/2?u=balupad14

https://forum.uipath.com/t/balareva-excel-activities-continue/68958

1.It has an custom components to generate the Pie,Column,Line,Bar charts for the excel data.

It has provision to copy the charts as image by using Image Copy property.
2.New Activity to rename the workbook sheet name Rename Work Sheet.

3.Column Hide/Unhide activity.

4.Row Hide/Unhide activity.

5.Copy Data activity.

6.Delete Data activity.

7.Clipboard To Datatable activity.

8.Merge Cells activity.

9.Unmerge cells activity.

10.Excel Export to Access activity.

11.Comment Activities (Add,Delete,Get,ShowHide).

12.Add Sheet and Delete Sheet Activities

13.Copy to WorkBook Activity

14.Copy to File Activity

15.Hide Unhide sheet Activity

16.Protect Unprotect sheet Activity

17.Create Workbook Activity

18.Insert Image Activity

19.Insert Table Format Activity

20.Set Password Activity

21.Get Sheets Name Activity

22.HyperLink Remove Activity

23.Find Replace Activity

24.Hyperlink Add Activity

25.Remove Duplicates Activity

To get more detail . Please take look this url

https://forum.uipath.com/t/balareva-excel-activities/38367/2?u=balupad14

https://forum.uipath.com/t/balareva-excel-activities-continue/68958

Release Notes

2.0.3 - New (Column,Line,Bar ) Charts included
3.0.0 - New Activity for renaming the sheet name
4.0.0 - New Activities added called Column and Row Hide/UnHide
4.0.1 - Display name Change
5.0.1 - New Activities added "Copy Data","Delete Data" and "Clipboard To Datatable".
6.0.0 - Merge Cells,UnMerge Cells.
7.0.0 - Excel to Access export option
8.0.0 - Comment Activities (Add,Delete,Get,ShowHide)
9.0.0- Add Sheet and Delete Sheet
9.0.1 - Adding Namespace for add sheet and delete sheet
10.0.0 - Sheets- Copy to (Workbook,File),Hide Unhide,Protect Unprotect,Create Workbook
11.0.0-Insert Image,Insert Table Format,Set Password
12.0.0- Get Sheets Name
13.0.0- Remove HyperLink - Imporvement in CopySheet to File
14.0.1-Find and Replace
15.0.0 - Renamed "Remove HyperLink " to "Hyperlink Remove".
15.0.1-Provision for modify password for all the excel related activities
16.0.0 - Hyperlink Add
16.0.1-Code refactoring
17.0.0-Remove Duplicates

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
17.0.0 (current version) 5,810 11/8/2018
16.0.1 1,097 10/27/2018
14.0.1 2,844 10/5/2018
13.0.0 1,378 9/26/2018
12.0.0 655 9/21/2018
11.0.0 896 9/15/2018
10.0.0 942 9/6/2018
9.0.1 208 9/5/2018
8.0.0 550 9/1/2018
7.0.0 261 8/30/2018
6.0.0 899 8/23/2018
5.0.1 396 8/21/2018
4.1.2 248 8/20/2018
4.1.1 740 8/11/2018
4.0.1 317 8/8/2018
3.0.1 1,608 7/20/2018
3.0.0 130 7/19/2018
2.0.3 183 7/18/2018
1.0.3 516 7/12/2018
1.0.2 1,250 6/29/2018