UiPath Go ! BalaReva EasyExcel Activities

Help Marketplace
, ,
183

Hi

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

185

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?

186

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

187

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.

image
image1240×751 42.5 KB

ExcelForumulaArea.zip (146.6 KB)

Regards
Balamurugan.S

188

@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

189

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

190

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

Regards. :+1:

1 Like
191

Thank you @Jefh

192

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.

image
image1226×724 65.4 KB

Regards
Balamurugan.S

193

Hi ,
Here is an activity to set Header, Footer, Margin , page setup and zoom .

image
image1885×894 68.7 KB

Regards
Balamurugan.S

194

Hi @balupad14 ,

Thankyou for your Activities Excel,PDF, etc. its really helpfull for me.
But this activity is only compability for Windows Legacy, is it possible to use BalaReva activities in compability Windows?

Regards,

195

HI @aliaga ,

I am doing the conversation about the migration with UiPath technical member. Soon you get all packages with migration. Thank you very much @aliaga

Thank you
Balamurugan.S

2 Likes
196

The migrated package has been published… Now you can get here

Thank you
Balamurugan.S

1 Like
197

Hi, @balupad14

I am trying to format cell, the specific cell starting from G2 and End would be dynamic, i tried Bala reva excel activity but it is failing.

image
image1253×565 27.9 KB

error:
image

198

Hi @RAKESH_KUMAR_Tiwari ,

  • First find the last row like below.

image
image1368×701 20.1 KB

  • Use the Change Cell type outside of excel scope.
  • Specify the range like this “G2:G” + intRowIndex.

Regards
Balamurugan.S

199

@balupad14
Using Easy Hyperlink
I would like to paste a link to cell B into cell A as a hyperlink, while keeping the text ‘1 2 3 4 5 6’ in cell A unchanged. Is there a way to overwrite only the URL while preserving the text? Thank you in advance!