How to use another excel file after massaging data using studio x

Help StudioX
,
1

hi i have a problem.

im using studiox x to automate excel. after massaging using studio x, i want to insert the info (using excel that i massage) into another excel template. can anyone help me with the workflow?’

im using studio x community

2

Hello @Nur_Amin

Certainly, here’s a concise version of the workflow using UiPath Studio activities:

Data Massaging Workflow:

  1. Open original data Excel file using “Excel Application Scope”.
  2. Manipulate data using Excel activities.
  3. Export massaged data to a new Excel file using “Write Range”.
  4. Store the exported file’s path in a variable.

Insert Data into Another Excel Template:

  1. Open template Excel file using “Excel Application Scope”.
  2. Read target range using “Read Range”.
  3. Open exported data Excel file using “Excel Application Scope”.
  4. Read data from exported file using “Read Range”.
  5. Insert read data into target range using “Write Range”.
  6. Format or manipulate data if needed.
  7. Save modified template using “Save Workbook”.

Thanks & Cheers!!!

3

hi can u help me with the workbook?

4

hi for the massage data, im using use excel file, then start with step massaging such as filter data table. then how to i start to open my template excel file to vlookup the info from the excel that i massage?

5

Sequence
├── Excel Application Scope (Read Massage Excel File)
│ ├── Read Range (Read data into massageDataTable)
│ ├── Filter Data Table (Apply filters and store in filteredDataTable)
│ └── Excel Application Scope (Write Template Excel File)
│ └── Write Cell (Write VLOOKUP formula)
└── End Sequence