Reading numerous files

[pabaleloh]

Good morning
I would like to read multiple files that the bot will download from Filezilla and save them to windows so i tried to use this solution but i am getting an error on read range workbook because the windows folder is empty the bot have not yet downloaded the file…which activity can i use or what can i write inside the read range?

Thank you

[pravallikapaluri]

Hi @pabaleloh

I think you are storing all the excel files in ProcessingFiles.
You need to pass the currentitem.tostring in the readrange activity

[lrtetala (Lakshman Reddy)]

Hi @pabaleloh

@pabaleloh

but i am getting an error on read range workbook because the windows folder is empty the bot have not yet downloaded the file…

Use wait for download activity or delay

Cheers!!

[Parvathy (PS Parvathy)]

Hi @pabaleloh

You need to pass currentItem since I think you are getting File Name in that. If you have still for queries I’m happy to help.

Regards

[sarvesh.b (Sarvesh)]

Hi @pabaleloh

Instead of Excel.xlsx in read range workbook activity pass currentitem.tostring as you are getting all the files in this variable and in range column give your range from where you want to read the data in your files.

[Parvathy (PS Parvathy)]

Hi @pabaleloh

What are you passing in the cell value? Can I know that?

Regards

[pabaleloh]

@Parvathy sorted thank you

[Parvathy (PS Parvathy)]

You’re welcome @pabaleloh

Happy Automation!!