Create Loop for each Excel File export a separate CSV

[Veskata (HR Ves)]

Hi, I have 10 excel files and i need to create a loop so each excel file exports into a separate CSV. I hope you get my point. Any idea how this can be created?

[Yoichi]

HI,

How about the following sample?

Sample20221021-1.zip (16.7 KB)

Regards,

[Veskata (HR Ves)]

Thank you i resolved this but I have another problem.
I’m downloading the excel files and I’m using the “Wait for Download” Activity. After that I’m using the Use Excel File Activity and the excel file is the Downloaded file .Tostring. The problem I have is that sometimes when UIPath opens the file this is what happens. Note that this is a loop so it downlaods multiple excel. Is there a way to fix this?

[Yoichi]

HI,

What is your problem, blank sheet or broken sheet etc?

Regards,

[Veskata (HR Ves)]

It just shows a blank sheet when trying to open the file.

[Veskata (HR Ves)]

And I don’t know what this name of the file is. The name of the file is completely different from the one showing.

[Veskata (HR Ves)]

Here are 2 images of the actions.

[Veskata (HR Ves)]

[Yoichi]

HI,

For now, uncheck “Create if not exists” option in UseExcelFile.
If you know file name which has blank sheet, please add its extension to “Ignore file extension” property in WaitForDownload.
If you haven’t know it, can you try to run debug, then check content of DownloadedFile variable at Locals panel when error occurs.

Regards,

[Veskata (HR Ves)]

I unchecked Create if not exists and I added the “tmp” extension to the Ignore file extension because the files causing the issue had this extension but now I am getting this error.

[Yoichi]

HI,

Please also add crdownload extension to IgnoreExtension property (It will be comma separated string as the following document.)

https://docs.uipath.com/activities/docs/get-last-downloaded-file

Regards,

[Veskata (HR Ves)]

I think it is okay now. Thank you so much!!!