Generate an Excel worksheet to provide word-level annotations

excel_dropdown_test.py

import xlsxwriter

# Create workbook with a new worksheet.
workbook = xlsxwriter.Workbook('hello.xlsx')
worksheet = workbook.add_worksheet()

# Write the tokens.
worksheet.write('A1', 'Hello')
worksheet.write('B1', 'world')
worksheet.write('C1', '!')

# Define options to choose from.
options = ['A', 'B', 'C']

# Insert the dropdown menu:
for cell in ['A2','B2','C2']:
    worksheet.data_validation(cell, {'validate': 'list', 'source': options})

# Write out the data, and close.
workbook.close()