UiPath Go ! BalaReva EasyExcel Activities

Good afternoon, have you ever encountered this error?
Clipboard To Datatable: Input array is longer than the number of columns in this table.

I`m trying to paste into the ‘null’ datatable.

1 Like

can you please share workflow with sample file. It will be helpful to me find out the problem exactly .

Thank you
Balamurugan.s

It appears to be the data issue. cells had parenthesis, dashes and front slashes(see below). After I left the text only it worked fine.
Case1 (test) Emergency
Case2 - Order (A/B/C)
Case3 - Customer
Case4 Stock (S)

It will be great, if this can be resolved, since I still need to use those characters in my data. the reason for the data table is a need to filter/subtotal the data and produce the report.

1 Like

Let me check with data and ping you…

Thank you
Balamurugan.s

1 Like

Thank you @balupad14!
On a side note. The “clipboard to datatable” will produce string-type columns, which will make the “Native group aggregation” unusable. Is there a better way to workaround it, other than looping through each column with the group by aggregation and building another data table?
Roman

Hi ,
Here is the video demonstration for find , find and replace.

Sample Project :
23FindReplace.zip (94.8 KB)

Video :

Thank you
Balamurugan.S

Hey is there a way i can use a loop to insert all the hyperlinks into an excel file

1 Like

Hi @Haleem_Muhammad,

Yes it is possible …

Check this video

Thank you
Balamurugan.S

1 Like

Hi @balupad14,

I am trying to use Freeze Rows activity to freeze output excel file header row but its giving me following error:

can you please help me on this?

2 Likes

Hi @Parveen_Shaikh,

Welcome to UiPath Community !

use the application scope from balareva easy excel like below.

Thank you
Balamurugan.S

Thank you for your email. It’s working now. Thanks for your help and guidance.

1 Like

You are always welcome !!!

Hi @balupad14, i follow your steps but gives me the following error:

Screenshot_3

How can i do that? thanks in advance

Hi ,

Hi @uidonna.jones,

Use the excel application scope from BalaReva Easy Excel…

Regards
Balamurugan.S

1 Like

thanks yes I have already solved , it was my oversight

1 Like

Hi @balupad14, what is your recommendation if I need to combine Excel Application Scope to say ‘write cell’ in a loop and BalaReva ExcelScope for the same file to e.g. find a replace?

1 Like

Hi @rchernysh,

Can you share a sample workflow. Maybe I can share my logic…

Thank you
Balamurugan.S

Thank you, I found a workaround, now I have another task/issue.
I need to make a copy of the excel sheet in the same file. Do you have a solution for that? I tried CopyToFile, but it didn`t work.

1 Like

HI @rchernysh,

If you want to copy in the same file, you have to use the activity “copy to workbook” .

Thank you
Balamurugan.S

Thank you! Silly me… I was trying to do it within the BalaReva Excel Scope. ughh… could`ve saved so much time, had I looked at the sample first…

1 Like