How to remove commas by excel operations?

Help StudioX
,
1

image

I want to remove the commas of the Amount column(if the commas exist), and if not, it will convert all of the column values to NUMBER. The input string may vary. The current input format of Amount Column is Accounting

How may I perform this action by excel automation conveniently and quickly?

2

HI @Tanzill_Ahsan
Welcome back to community

Try like this

  • Use Read Range and rea the excel and store in a variable.

  • Enable modern activities in the filter
    image

  • Use Excell Process Scope

    • Use Excel File
      • Find/Replace Value and pass as in the SS

image

Download the package BalaReva.Excel. Activities
image
And use change cell type activity and refer this link to know about the activity

Regards
Gokul

3

thank you @Gokul001

but I am not finding the activities that you have mentioned in your SS. Here I am adding the design of mine.

image
image1047×515 25.2 KB

4

Have you enabled modern design ?

5

Okay you can also use this

image
image1061×485 23.3 KB

You have given cell range statically instead use like this

“C2:C”+DtVariable.Rows.Count.tostring

I think so the last line will be not replacing anyping in the excel if the last row of the excel did not get updated use this

“C2:C”+(DtVariable.Rows.Count+1).tostring

Regards
Gokul

6

@Gokul001 yes I did

7

image
image1048×538 27.1 KB

Still the comma is visible on the excel file after a successful run of the uipath project file
@Gokul001

8

Then you will able to find that
image

What version of studio are you using and what is the version of the excel.actvities are you using?

9

@Gokul001

Version of UiPath Excel Activities 2.12.0
Version of UiPath Studio
image

10

Do you have any license for you your machine?

11

No, I do not have

12

So can you uninstall the studio and download the stable version from orchestrator?

13

OK thank you

14

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