UiPath Go ! BalaReva EasyExcel Activities

[pari_patel]

Is there any way that I can insert hyperlink for entire column. I have one column woth text which I want with hyperlink and rename.

[balupad14 (Balamurugan)]

Hi @pari_patel ,

do you mean the range like 1 to 1048576 ?

Regards
Balamurugan.S

[pari_patel]

Hi @balupad14

Yes, coreect … I have 1500+ rows in one column that need to active hyperlink.

[pari_patel]

I want to delete rows without deleting headers as I am filtering rows before delete. Can you suggest me how to keep Headers?

[balupad14 (Balamurugan)]

HI @pari_patel ,

You this activity you can delete all the rows without losing the column format.

Delete row excel

Hi @fairymemay, Take a look this activity to delete the row. Video demonstration : [Uipath | excel delete rows | excel delete columns | excel copy as picture (BalaReva)] Regards Balamurugan.S

if you don’t know the last row of the sheet, you can use this activity to find the last row of the sheet.

Get last column with row value

Hi @deepak_raj, Here is an activity called “Find last column” to find the last column index. Video demo : [UiPath excel Extract Graph as Image | find last column Index| find last Row No (BalaReva)] Regards Balamurugan.S

Regards
Balamurugan.S

[pari_patel]

Thanks I will try.

[pari_patel]

Hey ,

Can you guide me how should I deselect some filter from column and then hit delete rows. I did try macro, filter table but it is working to select . I want to deselect from multiple data (Excel filter)

[Anand_P (Anand Percherla)]

Hello Balamururgan,

I added your package Balareva.EasyExcel.Activities into my macro and it is running successfully in the studio. But it is getting failed in Orchestrator with the error (see image). package version is 29.1.1. Iam using this actvity to copy complete column data from Csv file and paste it into SAP Clipboard.

Could you look into this error and advise any corrections. Thank you in Advance

[balupad14 (Balamurugan)]

Hi @Anand_P ,

Thank you for using the package. Can you please share me the configuration of the robot machine(CUSSQR3E219C). Which version that you have installed it (Mainly the .net framework)

Thank you
Balamurugan.s

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

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?