Reading multiple excel files using tFileList and display the name of files

[kuwaryogi27]

Hi All,

I want to display filename's of the current excel file fetched using tFileList, can you please help me?

Regards,
Yogesh.

[vapukov · Accepted solution]

Hi Yogesh,

after tFileList you could use tJavaFlex  and in the main section

System.out.println(((String)globalMap.get("tFileList_1_CURRENT_FILE")));

regards, Vlad

[kuwaryogi27]

Hello @vapukov ,

Thanks this worked for me.

Regards,
Yogesh.

[kuwaryogi27]

Hi @vapukov ,

Can you help me in archiving the files based on their names, suppose the excel's name contain either abc or xyz in files i want to archive them on thier name basis.

Regards,
Yogesh.

[joearun4u]

Hi Yogesh,

If you want to archive the files based upon the file mask, you can find a option in tFileList as below

You can give the file mask to filter the files and use tFileCopy to copy the files in your required destination as follow

Thanks,

Joe

Dont forget to give Kudos/Solution if you find this tip is useful

[vapukov]

hi Yogesh,

if you mean as "archiving" - relocate files, the answer from @joearun4u would be good