保存二维的numpy数组
参考
https://blog.csdn.net/qq_43657442/article/details/108735931
作用
tmp =[[1,2,3,4],[5,6,7,8]]
[1,2,3,4] 和[5,6,7,8] 分别保存在表格不同列
例子
import xlwt
import numpy as np
def saveMatrix2Excel(data, path):
# 将np的矩阵数组保存至表格
data =data.T
f = xlwt.Workbook() # 创建工作簿
sheet1 = f.add_sheet(u'sheet1', cell_overwrite_ok=True) # 创建sheet
[h, l] = data.shape # h为行数,l为列数
for i in range(h):
for j in range(l):
sheet1.write(i, j, float(data[i, j]))
f.save(path)
W =[[1,2,3,4],[5,6,7,8]]
# 转成np数组
W = np.array(W)
pathW = "w.xls" # 保存在当前文件夹下,你也可以指定绝对路径
saveMatrix2Excel(W,pathW)