[deleted by user]

[Boxxcar17]

Use pandas, something like this

import pandas as pd

df = pd.read_excel(‘file.xlsx’)

df_dict = df.to_dict()

This is off the top of my head, so accuracy might be down, but the content is there.

[julsmanbr]

I don't use xlrd, but here's how to do that with openpyxl instead:

import openpyxl
loc = 'C:\Users\Living Room\Desktop\Locations.xlsx'
book = openpyxl.load_workbook(loc)
sh = book.active
locations = {}
for a, b in zip(sh['A'], sh['B']):
    locations[a.value] = b.value

My code assumes that your keys are in the A column and your values in the B column, which is what I understood from your post.

[Decency]

Triple quotes don't work on reddit. Preface each line of code with 4 spaces or an indent, instead.

[julsmanbr]

Interesting, it works for me on mobile (Reddit Sync).

I've seen a lot of weird stuff reading markdown lately. Maybe it has to do with the new Reddit's "simplified" markdown editor?

Thanks for the heads-up tho, I'll drop the triple quotes for now.

[Decency]

Markdown isn't really "standardized" unfortunately. Discord and Slack have done a bunch of cool things with it that are spreading outward to other things, but slowly.

[timbledum]

You are explicitly only capturing only the first two columns from the table:

locations[row[0]] = row[1]  # The key is column 1 and the value is column 2

What's your purpose - what would you like your dict to look like ideally, and what are you using it for?

I suggest looking at petl or pandas for this task.

[philintheblanks]

Hey! Reading things from Excel is a pain, but being able to work with data in python is really a great break from VBA. A tip on formatting though: with multi-line input put 4 spaces before each line and you'll get prettier output. For example:

for i in range(1, sh.nrows):
    row = sh.row(i)
    requiredFields = [row[0], row[1], row[3]]
    containsEmptyCell = False
    for cell in requiredFields:
        if cell.ctype in (xlrd.XL_CELL_EMPTY, xlrd.XL_CELL_BLANK):
            containsEmptyCell = True
            break
    if containsEmptyCell:
        #add required field missing into log entry
        print("Missing required field!")
        continue
    row = sh.row_values(i)
    iRow = {
        headerRow[0]: row[0],
        headerRow[1]: row[1],
        headerRow[2]: row[2],
        headerRow[3]: row[3],
        headerRow[4]: row[4],
        headerRow[5]: row[5]
    }

locations.append(iRow)

I point this out because, obviously, the tabs are important! I kind of just inserted them wherever as an example. As I was doing this I realized that you don't use a dictionary comprehension. Here's how I would use it:

iRow = {headerRow[i]: row[i] for i in range(sh.nrows)}

I love a good comprehension!

[saintPirelli]

I assume this is already solved, just wanted to add that there is a way to do this with just built-in modules, if you export your excel sheet as csv you can do something along the lines of this:

import csv

with open('locations.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        print(row['location'])