Opening files with "xxx.csv.yyy"

excel
studio

#1

Hi guys, I’m wondering if there is any way to efficiently and effectively open a file with “xxx.csv.yyy” format by automation.
Manually, we would need to open an excel application first, click open files, select “all files” and choose the file we want or by dragging the file into an open excel application. I’m trying to automate it the first way because uipath does not support drag and drop.

But Ive been facing a lot of issues, making sure that the bot click the ui elements i want it to.
Additionally, when I get to the folder where I save those files, I have to teach it to search for the file I want, but I don’t actually have the file name (the file name is saved as a continually changing variable), Im afraid if I ask it to look for ocr text, it might not be able to find it due to the limited number of files shown on the open dialog box.


#2

Is that file in the CSV format? If so, you can use the Read CSV activity even if the extension is not .csv.

If you already tried that, what was the problem?