nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Variable_from_excel.py

RiyasDeen

Variable_from_excel.py.zip

Vind meer berichten getagd met

Reacties

RiyasDeen

Hi Xander,

Thanks for the pointers, should agree your code looks more elegant than mine.

Regards

Riyas Deen

XanderBakker

Some pointers...

You don't need to use "gp = arcgisscripting.create()". Arcpy come with "AddMessage" too
You can use the "index" method on a list to get the index (will raise an error if the key field is not found)
Replace the dictionary.has_key(key) for key in dictionary. This adds to the readability
Will omit any field placed on the left of the ID field.

import arcpy

def Message(sMsg):

print sMsg

arcpy.AddMessage(sMsg)

# configuration

table = "C:\Users\deenr\Desktop\Data.xlsx\Sheet1$"

keyField = "ID"

fields = [fld.name for fld in arcpy.ListFields(table)]

fIdx = fields.index(keyField)

dictionary = {}

with arcpy.da.SearchCursor(table, ("*")) as cursor:

for row in cursor:

idx = 0

for cell in row:

if idx == fIdx:

if not str(cell) in dictionary:

dictionary[str(cell)] = []

else:

if str(row[fIdx]) in dictionary:

dictionary[str(row[fIdx])].append(cell)

idx += 1

# Print whole dictionary

Message(str(dictionary.items()))

for key in dictionary.keys():

# Print Values

Message(str(dictionary[key]))

Kind regards, Xander

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.