Write excel file
from openpyxl import Workbook
# Create a new execl
wb = Workbook()
ws1 = wb.create_sheet("Mysheet")
# Activate sheet
ws1 = wb.active
list = [1, 2, 3]
# insert data
ws1.append(table.row_values(index))
# preservation
wb.save(filename="ruijin_n.xlsx")
read excel file
import xlrd
# Open file
data = xlrd.open_workbook('ruijin_t.xlsx')
# selection sheet
table = data.sheets()[0]
# Pick columns
col_10 = table.col_values(10)