BalaReva.Excel.Activities Continue

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
image


Properties

image

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

2 Likes

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 :
image


AutoFitColumns

Properties :

image

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 :

image

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 .

Package : BalaReva.Excel.Activities.2019.0.1.zip (50.6 KB)

Thank you
Balamurugan

1 Like