Excel File Reading_0111

[Gokul_Murali]

Hello guys,

i have a folder containing excel it should take excel if there else it should throw no excel.

[Anil_G (Anil Gorthi)]

@Gokul_Murali

Use Directory.Getfiles("Folder","*.xlsx") this can be stored in a variable array of string

use if condition if arr.count>0 then file exists else throw error

cheers

[Gokul_Murali]

@Anil_G
thank you so much man

[Gokul_Murali]

@Anil_G

One more (Using ReFramework)

if there is any system exception i want to write a remark in excel.

so where can i use the write cell activity for any system exception.

[Anil_G (Anil Gorthi)]

@Gokul_Murali

1. In the exception block on process transaction
   or
2. Set Transaction status system exception sequence

cheers

[Gokul_Murali]

@Anil_G

See i hae used like this but didnt worked.

[Anil_G (Anil Gorthi)]

@Gokul_Murali

Ideally it would…can you please check by using a break point or step into

cheers