模块：openpyxl（Excel表操作）（实例1：基本写入，获取单元格数据类型）

from openpyxl import Workbook
from openpyxl.utils import get_column_letter    # get_colum_letter(2) 返回第二列的编号：B
import datetime

wb = Workbook()
file_name = 'workbook_1.xlsx'

ws1 = wb.active
ws1.title = 'range names'

    # 写入40行 599列
for row in range(1,42):
    ws1.append(range(600))

ws2 = wb.create_sheet(title='P1')       # 新建工作表命名为P1
ws2["F5"] = 3.14

    # 新建名为Date的表，写入行：10-20 列：27-54的数据
ws3 = wb.create_sheet(title='Data')
for row in range(10,20):
    for col in range(27,54):
        _ = ws3.cell(column=col, row=row, value="{0}".format(get_column_letter(col)))   # 写入返回的编号

    # 返回单元格数据类型
ws4 = wb.create_sheet(title='dateTime')
ws4['A1'] = datetime.datetime(2010,7,10)
print(ws4['A1'].number_format)


wb.save(file_name)