Convert dictionary to datatable to send to excel

[aksh1yadav (AKSHAY YADAV)]

@charliefik

I want to send the contents of a dictionary to Excel. I was wondering if there is a quick way of converting a dictionary to a datable so that I can then use write range, or should I just loop through the dictionary and write the dictionary key and data into the Excel worksheet line by line.

Hey @charliefik

you can follow @Divyashreem steps.
just adding one point for more clarification.

@Divyashreem

have a loop for dictionary

Use a for each loop with argument
System.Collections.Generic.KeyValuePair<System.String,System.String)

If still having doubt you can look into attached old sample - Convert_Dict_To_Datatable.xaml (10.1 KB)

Regards…!!
Aksh