Do we need to merge all the CSV files into one xlsx file during runtime of robot in uipath academy 2 second assignment?


#1

Do we need to merge all the CSV files into one xlsx file during runtime of robot in uipath academy 2 second assignment?


#2

All of the ones associated to the specific business and year. Each company/year would have a different xlsx.


#3

Thanks
Do we need to create it manually or with bot?


#4

The bot should do it.


#5

Ok got it.
Could you please discuss the steps to acheive that.


#6

Just need a overview of that.Got stuck here while implementing it.


#7

Waiting for your reply :blush:


#8

I would start with the Append Range activity. It’s nice because it will append to the file if it exists. If not, it will create it.

Just make sure you follow the naming convention listed in the instructions for the file


#9

Got it…will let you if I will get stuck…hope it works


#10

Are you using queues there?


#11

Could you please explain it elaborately…


#12

Yes, when I did this exercise I used queues. Unfortunately I can’t get into detail at the moment.


#13

No issue