脚本

输入内容，在绿色下拉列表中选择该脚本，点击运行。

# 删除下方 2 行显示导入，会隐式导入
import xlwings as xw
from xlwings import script

@script
def hello_world(book: xw.Book):
    sheet = book.sheets.active
    sheet["A1"].value = "Hello World"

A
Hello World

如果去掉类型注解。

Traceback (most recent call last):
  File "", in custom_scripts_call
  File "/lib/python3.12/site-packages/xlwings/pro/udfs_officejs.py", in custom_scripts_call
    raise XlwingsError(
xlwings.XlwingsError: Scripts currently only allow Book and CurrentUser as params