[Solved] convert dictionary into xls file using python openpyxl library


import csv
one_year_reserved = {
        'australia-central': 0.0097,
        'usgov-virginia': 0.00879,
        'us-south-central': 0.00731,
        'france-south': 0.01119,
        'us-west': 0.00719,
        'europe-north': 0.00822,
        'asia-pacific-east': 0.0097,
        'japan-east': 0.00799,
        'west-india': 0.00833,
        'united-kingdom-west': 0.00685,
        'usgov-arizona': 0.00879,
        'brazil-south': 0.00982,
        'australia-east': 0.00776,
        'us-west-2': 0.00605,
        'asia-pacific-southeast': 0.00776,
        'south-india': 0.01005,
        'us-central': 0.00731,
        'us-east-2': 0.00605,
        'south-africa-west': 0.01016,
        'canada-central': 0.00674,
        'south-africa-north': 0.00811,
        'canada-east': 0.00685,
        'us-east': 0.00605,
        'korea-south': 0.00639,
        'united-kingdom-south': 0.00685,
        'europe-west': 0.00696,
        'japan-west': 0.00879,
        'australia-southeast': 0.00776,
        'us-west-central': 0.00731,
        'us-north-central': 0.00605,
        'central-india': 0.00833,
        'korea-central': 0.00799,
        'usgov-texas': 0.00879,
        'france-central': 0.00856,
        'australia-central-2': 0.0097
    }


with open('output2.csv', 'wb') as output:
    writer = csv.writer(output)
    for key, value in one_year_reserved.items():
        writer.writerow([key, value])

0

solved convert dictionary into xls file using python openpyxl library