用pywin32编写阵列以表现出色

Question

我试图将阵列写入Excel。代码片段在下面。

导入win32com.client as win32 导入系统 导入numpy作为NP ＃------------------- 如果 name ==“ main ”：

name="nlve9.xlsm"
excel=win32.Dispatch('Excel.Application')
sheet=excel.Workbooks(name).Worksheets('NLVE')
#--------------
testress=np.zeros(5000)
for i in range(0,5000):
    testress[i]=float(i)

sheet.Range("AC18:AC5016").value=testress
#excel.ScreenUpdating = False
#for i in range(18,5017):
#    sheet.Range("AC" + str(i)).value=testress[i-18]
#excel.ScreenUpdating = True
sys.exit()

When this runs, I get a column of zero the length of testress.  When I replace the last line with below it works but it is excruciatingly slow.  THs is part of an optimization problem so this will run hundreds of times. Hence, I need this to be fast.

for i in range(18,5017):
    #    sheet.Range("AC" + str(i)).value=testress[i-18]

我在第一个方法中做错了什么（sheet.range（“ ac18：ac5016”）。值= testress）？

Answer 1

如果您使用range.value属性来设置数组，则Excel需要2D阵列的行＆amp;列值，即使您的数据是1D数组。

[[R1C1，R1C2，...]，[R2C1，R2C2，...] ...]

作为示例：

import win32com.client as wc

xl = wc.gencache.EnsureDispatch('Excel.Application')
xl.Visible = True

wb = xl.Workbooks.Add()
sh = wb.Sheets[1]

sh.Range('A1:A10').Value = [[i] for i in range(10)]

屈服：

net/v3nun.jpg“ rel =“ nofollow noreferrer

”代码，更改：

testress=np.zeros(5000)
for i in range(0,5000):
    testress[i]=float(i)

sheet.Range("AC18:AC5016").value=testress

到：

rowCount = 5000
testress = [[i] for i in range(rowCount)]
sheet.Range('AC18:AC'+str(18+rowCount-1)).Value = testress