python打开xlsm,python - 使用python在excel xlsm上写数组时拒绝Errno 13权限 - 堆栈内存溢出...

我正在尝试通过以下公式将协方差矩阵粘贴到现有xlsm文件上，但是它不起作用。 Cov Matrix是一个数组。 你能帮我吗？

Error I get is: [Errno 13] Permission denied: 'C:\\Users\\gm\\AppData\\Local\\Continuum\\anaconda3\\Files for Python\\Book2.xlsm'

shrunk_covariance = array([[0.44067332, 0.16161585], [0.16161585, 0.80226294]])

创建协方差矩阵的代码(您可能无需查看它，但此处出于完整性考虑)：

import numpy as np

from sklearn.covariance import LedoitWolf

real_cov = np.array([[.4, .2],[.2, .8]])

np.random.seed(0)

X = np.random.multivariate_normal(mean=[0, 0],cov=real_cov,size=50)

cov = LedoitWolf().fit(X)

shrunk_covariance = cov.covariance_

shrunk_covariance

无效的代码：

import openpyxl

from openpyxl import load_workbook

wb = load_workbook(r"C:\Users\gm\AppData\Local\Continuum\anaconda3\Files for Python\Book2.xlsm", keep_vba = True)

# grab the active worksheet

ws = wb['Shrunk_CovLast']

# Data can be assigned directly to cells

ws.cell(row=1,column=1).value = print(shrunk_covariance)

# Save the file

wb.save(r"C:\Users\gm\AppData\Local\Continuum\anaconda3\Files for Python\Book2.xlsm")