Data from one sheet of Excel extract to three sheets and then make a 3 csv files

Dear All,

I am struggling to create a robot that uses an information from one excel sheet and then takes data from different columns in this sheet and creates 3 different sheets which are then turned into csv files.

Thank you in advance for your help!

Best,
Anamarija

Hi,

If my understanding is right, the following sample will help you.

dictColumn = New Dictionary(Of String,String())From{{"1",{"a","b","c"}},{"2",{"d","e","f"}},{"3",{"g","h","i"}}}

dtTemp = dt.DefaultView.ToTable(False,CurrentItem.Value)

Sample20230628-1aL.zip (7.5 KB)

Regards,

1 Like

Dear Yoichi,

Thank you very much for the help - it means a lot! :smiley: What I forgot to mention is that I also need to rename the columns from the excel during this export to csv format. Is there a way to do it in UiPath?

Best regards,
Anamarija

Hi,

Hope the following sample help you.

Sample20230628-1aLv2.zip (7.9 KB)

Regards,

Thank you so much! It saved me :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.