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