BalaReva.Externals.Activities

[Krishna_547 (MudhuKrishna)]

Hi @balupad14

I am not supposed to use any external activities .I need code for unzipping .gz file can you please send

Thank You

[srdjan.suc]

I have a problem with Exchange Rates activity in a sense that i get exchange rate of 0 (Using provided ZIP file)

[balupad14 (Balamurugan)]

Hi @srdjan.suc ,
Now the service provider has been made some changes.I will update it and get back to you.Thank you for your valuable feedback.

Regards
Balamurugan.S

[Liwq (Wayne)]

Hi I used Log Text activity, but I found there is “:” in Timestamp, how can I remove it, thanks in advance.

[balupad14 (Balamurugan)]

Hi @Liwq,
You can use the find replay activity which is from the below link.

UiPath Go ! BalaReva EasyExcel Activities

Hi, A situation to find and replace the text inside the Excel. For that purpose, I have developed some activities below. Find - Find the text inside the sheet. It will return the cell info as an array string and row indexes. FindReplace - Find and replace the text inside the Excel sheet. [image] [image] Regards Balamurugan.S

Regards
Balamurugan.S

[Shreyash_Singh]

Hi, can you please add an activity to remove the graph/chart or an activity to update the graph

[balupad14 (Balamurugan)]

HI @Shreyash_Singh,

Already you have an activity to refresh the graph using the this activity Refresh All which is exists in the below.

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Note :

I will give an activity to remove the chart / graph from excel.

Thank you
Balamurugan.S

[111316 (Антон Макаров)]

Hello. Didn’t find a topic about Sheets.Activities. My question is about “Change Cell Type” one. I use it to make Numeric type, using this code: “#0.0000 ₽”. And it works, but only for the cell, NOT the data inside it. Autosum doesn’t see the number…
I have to enter a file with Excel, get inside every cell and push “Enter” - only after this the data becomes financial and Autosum works. How to apply types automatically???

[balupad14 (Balamurugan)]

Hi,
Check this one !!

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

Regards
Balamurugan.S

[111316 (Антон Макаров)]

Hi, that topic did not help.
I need to APPLY TYPES TO DATA, but not only to cells. Instead I have to enter a file with Excel, get inside every cell and push “Enter” - only after this the data becomes financial and Autosum works. How to apply types automatically not only to cells but also to data inside of them, that Autosum will see it as a number???

[balupad14 (Balamurugan)]

Hi @111316,

Can you explain with example file ?

Thank you
Balamurugan.S

[111316 (Антон Макаров)]

Results.xlsx (9.3 KB)
I am trying to scrap the currency course dynamic for ten days from here: https://yandex.ru/news/quotes/2002.html And paste it to Excel file using “Write Range”. Then use Change Cell Type and get the file attached. Types are not applied. What do I do wrong? How to apply types for using in Autosum?

[111316 (Антон Макаров)]

Here I found the same problem: How to Refresh Cell Data After Applying Number Formatting in Excel
We need our Change cell Type activity to apply the types to data, or we will have to make Great and loooong loops of double-clicking in all our cells to apply formats manually.
Please, give an explanation or make a patch to solve this.

[111316 (Антон Макаров)]

Tell me please, how to choose “financial” type without using a custom code “#0.0000 ₽”. Because users code (custom code) creates a type applying problem. You still need to fix a applying problem, but for me it would be easier to learn how to apply “finfncial” without custom format in Excel.

[Bob_Yan_EEL_TCE_PE_Sample (Bob Yan /EEL/TCE/PE/Sample Development)]

Hi Balupad,

I want to zip one or several files, not folder. For example, I want to zip a Excel file, how can I do with “zip activity”? Thanks!

[balupad14 (Balamurugan)]

Hi @Bob_Yan_EEL_TCE_PE_Sample,

Welcome to UiPath Community !

Here is a picture present that how to do the zip with multiple files.

Install the package :

Usage :

Regards
Balamurugan.S

[Bob_Yan_EEL_TCE_PE_Sample (Bob Yan /EEL/TCE/PE/Sample Development)]

Hi Balupad,

I can zip the file! thanks~~~

[geeks (Geeka)]

Hi Bala,

For the “Download File” activity i am getting an exception at WebClient Request exception, Any idea if i missed anything.

regards
Bhusan

[balupad14 (Balamurugan)]

Hi @geeks,

Welcome to UiPath Community !

No. I don’t idea. Can you explore it or send the example please …

Thank you
Balamurugan.S

[geeks (Geeka)]

Thanks Bala for the Quick Reply, Have uploaded the configuration and exception which I received from UI Path. This system where UI Path is installed out of office firewall.

Regards
Bhusan