Fill Values Based on the Excel Values

Dear team,
can you help to achieve the excel like automation like below
1st table sheet is what need to be automated in a way like in second sheet.
Kindly assist.

image

if required i can send the file.
please help!

@Nabeel_Ahamed

Welcome to the Community!

Can you please share the file and also confirm if the input excel would have the colours by default?

Yes venkat

But colors are not unique always

please find the attached sample file.

ui path doubt.xls (42.5 KB)

Hi @Nabeel_Ahamed,

Please see attached a sample workflow that reads the excel, creates two additional columns (“City” and “Hospital”) on the input table and sets the city and hospital/cliinic names on the relevant rows.

MergedCells.xaml (16.8 KB)

Hi @goodoldme,
Thanks but how do you print the output datatable in excel/csv because im getting error while doing it. image

Hi @Nabeel_Ahamed,

The input for Write Range should be a DataTable (dt_Test in the xaml that I shared earlier) and not strTable as it’s a String

thanks @goodoldme
it worked but only one last thing.

in my proposed sheet i dont want to display s.no and headers again and again.
please see the below screenshot
rest everything is fine except headers which needs to be removed after first occurence
image

Hi @Nabeel_Ahamed,

I suggest you give it a go and give a shout if you face any issues.