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

3 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

@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.

1 Like

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

Zahid1.zip (11.8 KB)

Regards
Balamurugan.S

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.

1 Like

Hi @Zahid1,
Already it has this feature.

Regards
Balamurugan.S
Regards
Balamurugan.S

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

1 Like