UiPath Go ! BalaReva EasyExcel Activities

thank every much, sloved my problem.

2 Likes

Hi @Chen_Kenny ,

It has to be upload into uipath market place !!!

Thank you
Balamurugan.S

Hello @balupad14,

First of all I’d like to thank you for your amazing work, several of your activities have come in very handy lately.

Specially the Copy As Picture has been a real life saver. I’ve been developina a robot on UiPath in a remote desktop that used that activity, until the remote desktop stopped functioning and I had to run it on my company laptop. Upon reinstalling the same packages as before and running the program, the Copy As Picture activity started malfunctioning, the pictures were saved with 0 bytes.

Could you advise me on how to solve this issue?

Best regards, Igor.

Hello @balupad14 ,

Thank you very very much for your iniciatives of creating such good activities for UiPath! You are already known in my company for being such a solution solver :smiley:

But by the way, I’m trying to use the Insert Hyperlink activity in my project, but it doesn’t work. I don’t know if I’m doing something wrong.

Despite of that, just one correction: It’s “Display Text Overwrite” not image

And I wish you all my bests mate! Good work!
Greetings,
Pedro Pais

Hello Mr Balamurugan,

In advance I’d like to say that your activities helped us a lot!

We’re facing some issue with the “CopyAsPicture” activity.
See below the problem : Capture

I’ve tried with the recent version 28.1.2 also with 24.0.0.
Do you happen to know what the problem might be?

Kind regards,
Pilisan

Hi @pilisan ,

You have to use the excel scope from BalaReve.EasyExcel

Thank you
Balamurugan.S

Mr Balamurugan,

Ok that worked, I should have known:)
Thanks for the quick reply.

Now facing the next issue :
Capture2

Always working with .png images but apparently this seems not to work.
Could it be because the cell content is too big? (just want to extract an image from 1 cell)

Thanks in advance for your reply.
Pilisan

Hello. I have a question about SetRangeStyle.
Is it possible to set a composite range in this activity, for example “A1: C1”+“A5: C5”+“A7:C7”?
Or is there any other activity for working with a composite range?

Hi @tatyana.grishina ,

Welcome to Uipath Community!

Yes. It is possible. you can give the range like this "A1:C1,A5:C5,A7:C7”.

image

Regards
Balamurugan.S

Hi @balupad14

first of all I would like to thank you for sharing your activitites with us. :wink:

I have two questions concerning your activities:
AutoFit Columns
How can I enter the range which I would like to edit? I have tried several ways of input, but all of them where quitted with an error message, as you can e.g. see here:
image

Furthermore I would like to know how I can format the cell with the ‘german’ format as we have the comma as the seperator for the decimals and the dot as the seperatot for the thousands.

I tried the format

“#.##0,00”

in your activity Change Cell Type, but this lead to this result

Before
image

After
image

Thanks for your input. :+1:

Hi @mbe ,

Thank you for using the activity.

For your first question.

The column range is array string. You have to assign like this. {“K:AC”}

Final one.

Check this video and for format check the video’s descripiton

Regards
Balamurugan.S

1 Like

Dear @balupad14
thanks for the advice to my first question and now it works. :+1:

To my second question:
I already found the video but finally I managed it with this short macro:

Sub Makro()
 Columns("G:Y").Select
 Selection.NumberFormat = "#,##0.00"
End Sub

Yours

1 Like

@balupad14 Have you removed “Remove Duplicate” activity from your package? Am not able to find this activity in any recent package version. Please tell me is there any specific version of package should i need to use this activity?

Thank you,
Avinash

1 Like

Hi @avinashpatil1711 ,

Welcome UiPath Community !
I didn’t. which version that you are using?

Regards
Balamurugan.S

I have downloaded v28.1.2 and i don’t find remove duplicate activity in this package version.

Thanks,
Avinash

Hi @balupad14 ,
I can’t find Function Cell Font in BalaReva EasyExcel(v28.1.2)
when I revert to an older version(v8.0.0) it is fail and show the picture down below

What should I do now?

Kind regards,
YM

Hi @avinashpatil1711 ,

The remove duplicates activity is in BalaReva.Excel activities. Not in the BalaRevaEasy Excel.

Thank you
Balamurugan.s

Hi @YM_1997 ,

The cell font activity name has been renamed as “Set Range Style”.

Thank you
Balamurugan.S

Hello,
I need your help. I used a Balareva “excel scope” to resize tables in excel. Since yesterday when I launch the workflow I have an error with this ‘excel scope’:
Excel Scope: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Do you have a way to debug this Please.

Hello everyone.

I’m getting this error:


Column Chart: The call was rejected by the call recipient. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))

I see that an Excel process is created, and I have to kill the process. But if I put also the kill process before to kill all Excel processes, the error keeps also appearing.