BalaReva.Excel.Activities Continue

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 .

Thank you
Balamurugan

4 Likes