How to AutoFit All Columns in Excel

[mazlumkacar (mazlum kaçar)]

Hi everyone,

I need to autofit all columns in excel sheet. I research it and find that there is an activity named AutoFit in BalaReva Package. But my enterprise uipath haven’t got that one. I don’t know why. Here is the ss:

And i still don’t know how i will autofit all columns.

[lakshman (Ganta lakshman)]

@mazlumkacar

Are you talking about these activities ?

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. This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using these activities you can able to generate the Column …

[mazlumkacar (mazlum kaçar)]

@lakshman yes but i cannot use this package because of uipath version. How will i fix it?
@balupad14

[lakshman (Ganta lakshman)]

@mazlumkacar

Go to Manage packages - > GO Package cources and search for that Package and install it. Then you will get all required activities from that Package.

[mazlumkacar (mazlum kaçar)]

@lakshman as i show in screen shots, i am already have this package but cannot use the last version of this package that include these activites. So there is no autofit activity here. That is why i am asking how can i autofit all columns.

[lakshman (Ganta lakshman)]

@mazlumkacar

Is the Installed Package version 2019.4.0 ?

Show me screenshot of Balareva.Excel.Activities Package version.

[kommijeevan (Jeevan Kommi)]

Hi @mazlumkacar

Regards,
Kommi Jeevan.

[mazlumkacar (mazlum kaçar)]

@lakshman @kommijeevan

[Manish540 (Manish Shettigar)]

You can install this package to autofit the columns,

[mazlumkacar (mazlum kaçar)]

Here is my page.

@Manish540

[Manish540 (Manish Shettigar)]

You can call below package , by adding it in settings of uipath.
AdvanceExcel.1.0.9.nupkg (9.6 KB)

[lakshman (Ganta lakshman)]

@mazlumkacar

Uninstall that Package and Install it again. Package version should be 19.4.0

[mazlumkacar (mazlum kaçar)]

i have just installed it but i don’t know what i should write this properties: FileName, Range, SheetName and AutoFit. Can you help me about this?

@Manish540 @lakshman

[kommijeevan (Jeevan Kommi)]

1.Column Range: A:D
2.File Path : where you save path of excel.
3.Sheet Name : what sheet you want auto fit columns.

[mazlumkacar (mazlum kaçar)]

@kommijeevan
@Manish540

And do you know what should i write the properties that “FontColor” and “FontStyle” ?

Cause i also want to make gray and bold a spesific row

[balupad14 (Balamurugan)]

Hi @mazlumkacar,

Apologies for the late reply. I thank you to @lakshman, @kommijeevan …

I have seen the screen shot @mazlumkacar. you are using the old version. You need update or new installation like below.

See the logo of the

Regards

[balupad14 (Balamurugan)]

To auto fit columns like below.

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

@mazlumkacar

@kommijeevan
@Manish540

And do you know what should i write the properties that “FontColor” and “FontStyle” ?

Cause i also want to make gray and bold a spesific row

Here is a the package (version 7.1.0) and it has an activity called “Cell Font” (you have to download and install it . Because I have submitted into the UiPath Go)

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Regards
Balamurugan.S

[Anu14 (ANU SINGH)]

Hi ,

I have a similar question- I want to autofit only visible columns.

For example: Columns- A,B,C,D,E,F,G (A,B,D are hidden)- I want to apply autofit to C,E,F,G columns only (visible ones)

I used the BelaReva activity and the Excel Extension activity- both are autofitting all the columns (making the hidden ones- visible on sheet).

Would appreciate some help.

Thanks.

[balupad14 (Balamurugan)]

Hi @Anu14,

Here is an activity called “Get Hidden Columns” to get the all hidden columns in the entire worksheet.

UiPath Go ! BalaReva EasyExcel Activities

Hi all, I have developed new activities called “Get Hidden Columns” and “Get Hidden Rows” version 10.0.0. [image] [image] Regards Balamurugan.S

Regards
Balamurugan,S