You would need to change the dbTable name to one of your tab names:
dbTable = "Domain1"
dbTable = "AccessSts"
The section of the code above after line 72 sets up the values used in the new_table function. In the example code, it creates 2 tables using 2 tabs in an Excel file.
Another way to read lots of tabs into domains without creating tables:
import xlrd
import arcpy
from arcpy import env
# name of geodatabase
geoDB = r"C:\Users\Randy\Documents\ArcGIS\PythonScripts\domains\domain_test.gdb"
# name of excel workbook
excelWB = r"C:\Users\Randy\Documents\ArcGIS\PythonScripts\domains\Parks_Domains.xlsx"
# lots of sheets in excel workbook, let's loop through them
xls = xlrd.open_workbook(excelWB, on_demand=True)
tabs = xls.sheet_names() # <- remeber: xlrd sheet_names is a function, not a property
isNum = ['ZipCode'] # list of tabs whose domain code is a number (not a number as text)
for tab in tabs:
print "Processing tab: {}".format(tab)
if tab in isNum: # if tab name is in number list, set type to long integer (or "SHORT")
fldType = "LONG"
else: # otherwise, set it to text
fldType = "TEXT"
print "\tCreating domain"
arcpy.CreateDomain_management(in_workspace= geoDB, # geodatabase
domain_name= tab, # tab name will be the domain name
domain_description= tab, # tab name will be the description
field_type= fldType, # set field type
domain_type= "CODED", # this is a coded value domain
split_policy= "DEFAULT",
merge_policy= "DEFAULT")
print "\tAdding codes and descriptions:"
sheet = xls.sheet_by_name(tab)
num_rows = sheet.nrows - 1
curr_row = 0
while curr_row < num_rows:
curr_row += 1
cd, desc = sheet.row_values(curr_row)
if fldType == "LONG": # if field type is long integer
cd = int(cd) # convert code to integer
print "\t\t{}\t{}".format(cd, desc)
arcpy.AddCodedValueToDomain_management(in_workspace= geoDB,
domain_name= tab, # tab name is the domain name
code= cd,
code_description= desc)
print "Done."
This uses a couple of other arcpy functions: Create Domain and Add Coded Value To Domain. The basic flow of the program is to add a domain for every tab in the workbook. It assumes a setup similar to the one in your Excel file.
Hope this helps.
