numpy - 无法激活工作表

Question

import openpyxl
import numpy as np

wb = openpyxl.Workbook()
hoja1 = wb.get_active_sheet()
hoja1.title = '1'

x = np.linspace(0,100,50)
y = x**2

hoja1.cell(row = 1, column = 1).value = 'x'
hoja1.cell(row = 1, column = 2).value = 'y'

for i in range(0, len(x)):
    hoja1.cell(row = i + 2, column = 1).value = x[i]
    hoja1.cell(row = i + 2, column = 2).value = y[i]

wb.save('test_save.xlsx')

所以这是我的代码。它适用于保存数据，但如果我想在同一个 test_save.xlsx 文件中创建另一个工作表，我必须做什么？我试过这个但没有成功：

import openpyxl
import numpy as np

wb = openpyxl.Workbook()
hoja1 = wb.get_active_sheet()
hoja2 = wb.get_active_sheet()

hoja1.title = '1'
hoja2.title = '2'

x = np.linspace(0,100,50)
y = x**2

hoja1.cell(row = 1, column = 1).value = 'x'
hoja1.cell(row = 1, column = 2).value = 'y'

for i in range(0, len(x)):
    hoja1.cell(row = i + 2, column = 1).value = x[i]
    hoja1.cell(row = i + 2, column = 2).value = y[i]

wb.save('test_save.xlsx')

但它不起作用=（

标签： numpypython-3.6openpyxl