UiPathGo - BalaReva Excel Activities

Hi ,
202000.0.0 is a testing version. The latest is 2019.10.1. Check that you have the version 2019.10.1.

Thank you
Balamurugan.S

No Bala I don’t find. Attached screenshot

Hi ,
You have selected only the dependencies. Select connect and see the package.

Thank you
Balamurugan.S

Dear All,
Here I have attached the sample project and video for Merge and unmerge cells.

Sample : MergeUnmerge.zip (33.1 KB)

Regards
Balamurugan.S

Hi balareva,
is it possible to merge the same value instead? for example instead of 1 Spain value on the first row, it duplicated through the whole row up till the next different value (portugal).
Also what if the range is dynamic?
Thanks

Regards,
Thery Tendyan

Hi @balupad14,

I try to use your activity “Auto Columns” of your package, as indicate here:

However, my table into my Excel is not extended.
Did you if this activity is adapted to my requirement?
Thanks.

Best regards,

Miguel

Hi @MigT,

Can you share a sample excel file please ?

Thank you
Balamurugan.S

Hi @balupad14,

Finally I find a solution to my issue.
Thanks

Miguel

1 Like

Hi @balupad14 i am facing this error on change cell type. excptn image

1 Like

HI @pravupada,

Can you share a sample excel file with workflow to see ?

And also take a look this video.

Thank you
Balamurugan.S

1 Like

thanks @balupad14 for replying
but i found the solution
The excel files were currupted

1 Like

Hi @balupad14 could you help, I’m trying to export an excel to pdf, there are multiple sheets in the workbook, but output pdf only has first sheet, how do I export all?

Hello Bala,

I am using Excel 2007. I am getting error as “Value does not fall within the range”

Regards,
SLKT

At I gave only to export single sheet. So you can export each sheet as each pdf. and then you can combine everything as a single pdf.

Thank you
Balamurugan.S

Dear all,
I got many requests from users. that to remove the Invalid Message box from the delete sheet activity.
Now I have removed the message. If the sheet exists, it will delete. Otherwise, it won’t do anything. in the version of 2010.1.1 you can see this change.

Thank you
Balamurugan.S

Hi @balupad14,

With your activity, is it possible to convert multiple sheets, from one Excel, as pdf.
If yes, could you explain how please. Because I try to add a string array with excel sheet name into the fiel “Sheet name”, unsuccessfully.
Thanks

1 Like

Let me check @MigT. and get back to you…

Thank you
Balamurugan.S

1 Like

Hello @balupad14,
I am trying to use the Hide/Unhide Row activity, but it is not performing properly. I tried outputting the execution results and it says True, but my rows are still hidden. Does something else need to be set in order for this to work? Thank you.

image

Hi @jdahlinger,
Thank you for your valuable feedback.
I tested at my side. It is working well. here is the output. I don’t know your real situation. But Here I have attached sample for you.

ExcelRowHide.zip (53.7 KB)

Thank you
Balamurugan.S

I was able to get this to work in my project, but only when I removed it from the Excel Application Scope that housed all of my other activities related to the file. Can you please confirm if your activities need to always be used outside of an Excel Application Scope? Thank you.