Excel write range datatype in column

Help Activities
1

hello,
basically i read an different excle sheets about 1000 rows and about 160 columns each + or -(not small range).
then i run some math, filtering, modifying values and i delete that range and rewrite it.

Some column values have too long numbers or stored separated by / or -
the issue for the long number when it’s written by Write range it goes like this
112+E15- but originally it’s like this 112024240662570

I understand the format is not preserved and if i tried to read range with Preserve format checked… it takes really too long to read it… i’m talking about over 30 min read range

if i manually change column from text format to Number it will look fine but how to manage it with UIpath ?

2

HI @mohammad.metwally

What is the activity are you used for Read and writing the data in the excel?

If you used Excel application scope just update the activity to Work book activities to Read and Write

Regards
Gokul

3

Another Way to achieve @mohammad.metwally

Try with BalaReva activity → Change cell format activity

image
image997×313 18.2 KB

Regards
Gokul

4

hello, i’m using excel application scope
because… i read range, filter rows, modify values, delete that range and then re-write it with new values. don’t want to use Balareva or any other packages other than official UIpath

5

Hi @mohammad.metwally

For Read range and Write Range alone use the Workbook activity. For Rest you can use Excel scope activities

6

Hi @mohammad.metwally ,

Could you try with Format Cells Activity ?

  1. We could use Read Range Activity from Excel Scope to read the Total rows present in the Sheet.

  2. Then use the Format Cells Activity to Format the Required Range as a Number like below :

    image
    image846×412 16.2 KB

Input :
image

Output :
image

Let us know if this is not the Expected answer you’re looking for.

1 Like
7

okay i don’t have that activity in my studio ! humm ?

8

@mohammad.metwally ,

Could you Let us know what is your Studio Version and Excel Activities version ?

Also, Be sure to enable Modern Design, so that you will have the new activities related to Excel that you could use (Requires Excel Activities version 2.11.3 or above )

Let us know if you are on a lower version and cannot update to a higher version.

1 Like
9

HI @mohammad.metwally

Go to Activity Panel → Filter → Select Show Modern

image
image322×590 17.3 KB

Or else

Go to Project Panel → Setting-> General → Disable the Modern Design → Click Ok

image
image1029×694 59.7 KB

Regards
Gokul

1 Like
10

@Gokul001 ,
i guess balareva activities are not available after the new UiPath update!

11

Hi @muhamed_fasil

It’s available in the Manage Package. Kindly check it out

image
image908×512 35.8 KB

In that post i have mentioned only Excel application scope activity and Workbook activity.

Regards
Gokul

12

okay i found these activity thanks to @Gokul001 mini tutorial, and literally mind blowing new activities that i didn’t know they existed.

My question about the activity source… what kind of args or variables it’s accepting ? i see your screenshot but cannot determine what to do. shall i put it inside excel application scope or just use it after the file have been completely processed and saved ?

13

@mohammad.metwally ,

You would need to use it within a Use Excel File within a Excel Process Scope Activities.

image
image714×464 13.9 KB

14

these activities aren’t in modern, they are in studio X
i have studio enterprise license, we just had server upgrade and my activities belonging to studio X disappeared… any idea how to get them back ?
Uipath 2022.4.5
Enterprise license

15

HI @mohammad.metwally

Go to → Activities Panel → Click on Filter → Select Show Modern.

image
image338×584 19.2 KB

You will get the Modern activities

Regards
Gokul

16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.