Browse each excel file then replace values but it's slow

Help StudioX
1

I’m using StudioX. My problem is like this:
File A: this is a master excel file, including 2 columns (old code column and new code column)

An Excel spreadsheet named "ReplaceMasterData.xlsx" displays columns "Old_Code" and "New_Code" highlighted in yellow, with corresponding numerical data entries. (Captioned by AI)
An Excel spreadsheet named "ReplaceMasterData.xlsx" displays columns "Old_Code" and "New_Code" highlighted in yellow, with corresponding numerical data entries. (Captioned by AI)702×328 14.2 KB

File B: in the content of this excel file, I need to replace all old codes with new codes (according to file A)

image
image909×432 23.8 KB

I have this problem: I use “For Each File in Folder” to read all B files in a specified folder. At first, UiPath runs very fast (about the first 200 files), but then it runs slower, then almost no work. I am guessing it is due to the memory of excel. Can someone help me?

Untitled1
Untitled1748×1342 53.5 KB

Thanks you for help me!

2

@mai-dinhngoc

It might happen due to memory issue only

Try to have deete temp files and then continue

Cheers

3

Do you mean delete in folder %temp%?
I tried it and it didn’t work.

4

@mai-dinhngoc,

Try Isolating the excel workflow.

How to do that?

  1. Move this logic into a separate workflow and invoke that workflow here.
    This image depicts the steps for reading and replacing values in Excel files, where each file is read, each row in a master file is processed, and values in file B are replaced based on corresponding values from columns B and C in file A. (Captioned by AI)

  2. Select Isolated property to True or checked of Invoke Workflow File

image

This will create another instance of UiPath Executor which will get closed or garbage collected once the workflow will finish execution.

5

I am using StudioX, can you tell me which control can I use to isolate the excel process? Can you give me detailed instructions?
Tkanks you!

6

@mai-dinhngoc

try using excel process scope

The image shows the configuration settings for an "Excel Process Scope" activity in UiPath, with options such as "Existing processes action" set to "Force kill" and "Show Excel window" set to "False". (Captioned by AI)
The image shows the configuration settings for an "Excel Process Scope" activity in UiPath, with options such as "Existing processes action" set to "Force kill" and "Show Excel window" set to "False". (Captioned by AI)1110×523 34.6 KB

cheers

7

Thanks you! I have direction.

1 Like