【原】自学numpy/xlwings

import xlwings as xw

import numpy as np

# 设置头文件

app = xw.App(visible=False,add_book=True)

app.display_alerts = False

app.screen_updating = False

# 新建工作簿

wb = app.books.add()

# 工作表重命名

wb.sheets[0].name = 'me'

# 新建工作表

wb.sheets.add('you')

# 删除工作表

wb.sheets[1].delete()

# 循环创建工作表

for i in range(5):

    sht = wb.sheets[i]

    wb.sheets.add(str(i),after=sht) # i不能为int，因此转化为字符型

wb.sheets[0].delete()

# 赋值

for i in range(5):

    sht = wb.sheets[i]

    if i == 1:

        sht.range('a1:c3').value = np.random.randint(10)

    elif i ==2:

        sht.range('a1:c3').value = np.random.rand(10)

    elif i ==3:

        sht.range('a1:c3').value = np.random.randn(10)

    else:

        sht.range('a1:c3').value = np.random.random(10)

# 保存、关闭

wb.save('first_book.xlsx')

wb.close()

app.quit()