how to dynamically write to an excel file in python using a dictionary code example
Example: how to save a dictionary to excel in python
import pandas as pd
dict1 = {"number of storage arrays": 45, "number of ports":2390}
df = pd.DataFrame(data=dict1, index=[0])
df = (df.T)
print (df)
df.to_excel('dict1.xlsx')