How to write dictionary values to an excel sheet

Question

In dictionary if i have key as “Name”,“Age”,“Id” and value as “Raju,Susha,Madhu” ,“21,22,23” ,“101,102,103”.how can i write this in to an excel as

NAME Age Id
Raju 21 101
Susha 22 102
Madhu 23 103
Can anyone please suggest how can i do this

Zaid Chougle · Answer

In dictionary if i have key as “Name”,“Age”,“Id” and value as “Raju,Susha,Madhu” ,“21,22,23” ,“101,102,103”.how can i write this in to an excel as

NAME Age Id
Raju 21 101
Susha 22 102
Madhu 23 103
Can anyone please suggest how can i do this

You can use the loop → for each value in dictionary along with a counter initialization to write in down vertically.

Sign up