Path or extension of excel

RPA Discussions
1

how to write path for 10 files in write range activity??

2

@guptasweb

You mean want to write Excel file paths into one excel file ?

3

path
what to write in circle area

4

@guptasweb

Write below expression.

     OutputFolder+FileName+".xlsx"

Here OutputFolder holds destination folder path and FileName holds file name and also both variables should be of type string.

5

i go this error

IMG-20220418-WA0013
IMG-20220418-WA00131600×1200 239 KB

6

@guptasweb

Is OutputFolder and FileName variables of type String ? Can you please share me screenshot of it.

7

variables
variables1378×295 59.7 KB

8

@guptasweb

It looks good only. Hope you are not using Workbook Write Range activity inside Excel Application Scope activity.

9

correct i m not using excel application scope

11

Flowchart.xaml (30.0 KB)

12

There might be 2 variables with the same name. Please check that.

Thanks!
Athira

13

no…all have different name

14

Hello,

Output folder variable is duplicate.

image
image1825×447 32 KB

Thanks!

15

thanks
Athira