Excel Automation in Studio X

Help StudioX
,
1

Please Help… Is there a way to add + 2 value in the value of the image below…
I use find in studioX to identify where the robot will write the data.

image
image

2

Hi @flashdrive07

Could you share the input excel file.

Regards

3

@mkankatala this is just a sample file…

Opportunities.xlsx (21.9 KB)

4

Hi @flashdrive07

You need to get the output as B12 right if I’m not wrong. Please specify

Regards,

5

yes that is right… and i can take care of the others

6

Hey @flashdrive07
you can use regular expression to do this:

image
image834×454 14.5 KB

image
image842×437 16.1 KB

image
image

working workflow you can find here:
NewBlankTask19.zip (68.8 KB)

7

Hi @flashdrive07

Check out the below process:

image
image854×1509 68.5 KB

After Find/Replae value activity use the below syntaxes in Set Variable Value activity:

Set Variable Value-> column= System.Text.RegularExpressions.Regex.Match(foundX,"[A-Za-z]+").Value.Trim()

Set Variable Value-> cal= Convert.ToInt32((System.Text.RegularExpressions.Regex.Match(foundX,"(?<=[A-Z]+)[0-9]+").Value.ToString.Trim()))

Set Variable Value-> cal=cal+2

Set Variable Value-> output= String.Concat(column+Cal.ToString)

Note: cal is of DataType System.Int32. column is of DataType System.String. output is of DataType System.String.

Output:

image
image1102×785 40.7 KB

Attaching the process flow of Studio X below:
Forum Task 2.zip (184.7 KB)

Hope it helps!
Regards

1 Like
8

Thanks Again Everyone!!!

1 Like
9

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