BalaReva.Excel.Activities Continue

[balupad14 (Balamurugan)]

BalaReva.Excel.Activities

The package is for the excel charts (Pie Chart) Package: BalaReva.Excel.Activities Author: @balupad14

I continue the above thread here due the length of the thread.

Hi Friends,
I have included a new activity called “Find Replace”. Using this activity can find and replace the text into the excel. It has the find option like below

Part		Match against any part of the search text
Whole		Match against the whole of the search text

---

Namespace

---

Properties

Samples :FindReplace.zip (7.8 KB)

Note :

The sample has been developed by the version of CE 18.3.
If you get any error let me know.
I would happy to receive more suggestion.

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

Hi Friends,
I have included some new activity in the package (AutoFitColumns,AutoFitRows,Format Cells).
Now you can get the package here. I have uploaded the package in the UiPath Go. After It is uploaded , I will remove the package from here.

Namespace :

---

AutoFitColumns

Properties :

Usage of Column Range
Single Column = { “A:A” }
Continuous Columns={“B:D”}
Multiple Columns ={ “A:A”,“D:D”, “E:G” }
Range of Cells ={“A1:D8”}

To set column width
AutoFit=False
ColumnWidth =specify width value

---

AutoFit Rows

Properties :

Usage of Row Range :
Rows Range = {1,5,6,8}

To set row height
AutoFit=False
RowHeight =specify height value

---

Format Cells
Properties

I think I don’t want to explain .

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Thank you
Balamurugan

[Zahid1 (Zahid)]

@balupad14: I am using your package for AutoFit Columns; In my scenario, sheet name is dynamic. Is there a way to by-pass the sheet name and only use path of workbook?

I want to use autofit columns for all the tabs of a workbook without giving the sheet name.

[balupad14 (Balamurugan)]

Hi @Zahid1,
Yes. Possible. Here i have attached the screen shot with example.

Zahid1.zip (11.8 KB)

Regards
Balamurugan.S

[Zahid1 (Zahid)]

Thanks a Lot @balupad14 ; it was really helpful.

Quick ques: any plans to add wrap text (excel) in your package in near future.
In my workbook, after Autofit, the no of chars is more than 255, so getting truncated.
I am using wrap text through Send Hotkeys but would really like to use your package for the same.

[balupad14 (Balamurugan)]

Hi @Zahid1,
Already it has this feature.

Regards
Balamurugan.S
Regards
Balamurugan.S

[Zahid1 (Zahid)]

@balupad14: Thanks a lot. This is really wonderful !!!
Update my workflow with this.

[MaxyArthes]

Hello, I just got your package and I can’t seem to find “Autofit”, was it removed?

[balupad14 (Balamurugan)]

Hi @MaxyArthes,

No. It is not removed. Below .

Manage and packages

Regards
Balamurugan.S

[MaxyArthes]

am I supposed to download it from a site? The 1 from “nuget.org” show only the v10.0.0 from 9/11/2018

[balupad14 (Balamurugan)]

You can use the manage and packages in the studio…

[balkishan (Balkishan Singh)]

you attached a blank workflow @balupad14