UiPath Go ! BalaReva EasyExcel Activities

[Anand_P (Anand Percherla)]

@Anand_P

Balareva.EasyExcel.Activities

Thank you for responding. For some reason I cannot get the Robot machine server details. But, after lot of testing I found that instead of this package - Balareva.EasyExcel.[Activities], I am able to resolve the issue with other package of yours - Balareva.Excel.Activties. Issue is fixed now

Thank you again Balamurugan!

[Rusira_Liyanage]

Hii @balupad14

Recently I tried to delete the column vise “Grand Total” in a pivot table and I used your “delete rows” activity but it didn’t work

Do you know a way to delete “Grand Total” columns in a pivot table in excel ?

[stellalai8625]

I can’t fin the Clipboard to datatable activity in the newest package version.

[balupad14 (Balamurugan)]

Hi @stellalai8625 ,

The activity exists in the “BalaReva.Excel.Activities”

Thank you
Balamurugan.S

[jmy (Jimmy)]

Hi is there any activity that can adjust cloumn width？
thx

正在上传：image.png(1)…

[balupad14 (Balamurugan)]

Take a look at this.

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 ColumnWi…

Note :

BalaReva has the enterprise version. It has more activities. Have time, take a look.

BalaReva - Excel Automation for Enterprises - RPA Component | UiPath Marketplace

Regards
Balamurugan.s

Regards
Balamurugan.S

[stellalai8625]

Hi @balupad14,

Is it possible to clear the entire excel sheet first (make the excel sheet blank) before paste from clipboard? If so, what are the activities I should use and which package? Thanks.

[balupad14 (Balamurugan)]

Hi @stellalai8625 ,

Delete the sheet and add a new sheet with the same name.

To delete from “Balareva.Excel.Activities”

Delete Sheet

Hi @Babita22, Welcome to UiPath Community Forum ! Here I have attached the sample to delete the sheet … Before Delete : [image] After Delete : [image] Design Screen: [image] Sample : Babita22.zip (30.5 KB) Package info : Regards Balamurugan.S

To add a new sheet from the same.

How to create sheet in excel

Hi @sruthesanju , Here is an activity called “Add Sheet” to add a new sheet in excel. here is the package. Regards Balamurugan.S

Regards
Balamurugan.S

[hsendel]

Dear @balupad14
Is the Package contains something that fix the following issue : How To Use Switch Statement to check if Values from Excel Column belongs to one Liste?

[javier.monasterio]

Hi @balupad14, could you help me with this problem? I’m trying to study a created process that uses your activities. When I open the project, im getting the following errors:

I`ve tried with all package versions but none of them worked.

[dcmf]

Hello

When I use the Extract HyperLinks activity the activity locks the excel document and the notification always appears and because of that the activity never works.

Has anyone who has had this problem managed to find a solution?

[davendra.patel]

Hi

I see in the latest version there is no hide & unhide column and rows? Why?

[421292267]

hello，
Why can’t I find the dependency package balareva excel scope in the new version? The old version has this balareva excel scope, but my project is developed in the new version. How can I get this dependency package?

[balupad14 (Balamurugan)]

Dear All,
Now you get the new release (31.0.0) of Easy excel. Here are the new activities that contains.

• Get Range Style
• Image Resize
• Average Range
• CountA Range
• Count Range
• Max Range
• Min Range
• Sum Range
• Create Group
• Collapse All Group
• Ungroup
• SaveAs Sheet

Thank you
Balamurugan.S

[balupad14 (Balamurugan)]

Hi All,

Don’t want to read the excel range and load into datatable to find the sum ,average ,min ,Max ,Count ,CountA . Here is the sample for the formula area activity.

ExcelForumulaArea.zip (146.6 KB)

Regards
Balamurugan.S

[Jefh (Jesus Fonseca)]

@UiPath_Community
@uipath

Please add this similarly package in (Manage Packages) UiPath Studio → please i need it in my project.

@balupad14 can you please migrate to use in (Windows projects) UiPath Studio

[balupad14 (Balamurugan)]

HI @Jefh

Thank you for using the package. I have sent a migrated package to UiPath. I am waiting the response from them.

Tagged to : @Forum_Staff , @staff

Thank you
Balamurugan.S

[Jefh (Jesus Fonseca)]

Hi @balupad14, I appreciate this news today . Thanks for bring the package to the community, this package is very useful.

Regards.

[balupad14 (Balamurugan)]

Thank you @Jefh

[balupad14 (Balamurugan)]

Hi,
In the BalaReva.EasyExcel.Activities. It has some activity to remove the filters.

1. If the filters applied in the table , use the “Remove Filter”
2. If it is not in the table use , “RemoveFilter NonTable”
   Here is the screen shot.

Regards
Balamurugan.S