Python编程

import xlrd

workbook = xlrd.open_workbook("MySpreadsheet.xls")

#for sheet in workbook.sheets(): # 加载所有工作表，与 workbook.sheet_names() 不同
for sheetName in workbook.sheet_names():  # 按名称迭代工作表
  print("Sheet name:", sheetName)
  sheet = workbook.sheet_by_name(sheetName)
  for rowno in range(sheet.nrows):
    for colno in range(sheet.ncols):
      cell = sheet.cell(rowno, colno)
      print(str(cell.value))  # 输出为字符串
      if cell.ctype == xlrd.XL_CELL_DATE:
        dateTuple = xlrd.xldate_as_tuple(cell.value, workbook.datemode)
        print(dateTuple)  # 例如 (2017, 1, 1, 0, 0, 0)
        mydate = xlrd.xldate.xldate_as_datetime(cell.value, workbook.datemode)
        print(mydate)  # 在 xlrd 0.9.3 中
      print()
    for sheetno in range(workbook.nsheets):  # 按索引迭代工作表
  sheet = workbook.sheet_by_index(sheetno)
  print("Sheet name:", sheet.name)
  for notekey in sheet.cell_note_map:  # 在 xlrd 0.7.2 中
    print("Note AKA comment text:", sheet.cell_note_map[notekey].text)
  print(xlrd.formula.colname(1))  # 列名，例如 A 或 AD，这里是 'B'

链接：

*   [xlrd, pypi.python.org](invalid URL removed]
*   [xlrd 1.2.0, pypi.python.org](invalid URL removed]
*   [xlrd 文档, readthedocs.io](invalid URL removed]
*   [xlrd API 文档, readthedocs.io](invalid URL removed]
*   [Python: xlrd discerning dates from floats, stackoverflow.com](invalid URL removed]
*   [xlrd.biffh.XLRDError: Excel xlsx file; not supported, 11 Dec 2020, stackoverflow.com](invalid URL removed]
*   [xlrd 2 released, 11 Dec 2020, groups.google.com](invalid URL removed]

**xlwt**

支持写入 .xls 文件。许可证：BSD。

链接：

*   [xlwt, pypi.python.org](invalid URL removed]
*   [xlwt 文档, readthedocs.io](invalid URL removed]

**openpyxl**

支持读写 .xlsx Excel 文件。不支持 .xls 文件。许可证：MIT。

读取工作簿：

```python
from openpyxl import load_workbook

workbook = load_workbook("MyNewWorkbook.xlsx")

for worksheet in workbook.worksheets:
  print("==%s==" % worksheet.title)
  for row in worksheet:  # 对于每行中的每个单元格
    for cell in row:
      print(cell.row, cell.column, cell.value)  # 例如 1 A Value
  for cell in worksheet["A"]:  # 对于 A 列中的每个单元格
    print(cell.value)
  print(worksheet["A1"].value)  # 单个单元格
  print(worksheet.cell(column=1, row=1).value)  # A1 的值

from openpyxl import Workbook

workbook = Workbook()
worksheet = workbook.worksheets[0]
worksheet['A1'] = 'String value'
worksheet['A2'] = 42  # 数值
worksheet.cell(row=3, column=1).value = "New A3 Value"
workbook.save("MyNewWorkbook.xlsx")  # 如果存在则覆盖

from openpyxl import load_workbook

workbook_name = 'MyWorkbook.xlsx'
workbook = load_workbook(workbook_name)
worksheet = workbook.worksheets[0]
worksheet['A1'] = "String value"
workbook.save(workbook_name)

import datetime as dt

@xloil.funcdef
def pyTestDate(x: dt.datetime) -> dt.datetime:
    return x + dt.timedelta(days=1)

import asyncio
import datetime

@xloil.funcasync
async def pyTestAsyncGen(secs):
    while True:
        await asyncio.sleep(secs)
        yield datetime.datetime.now()