在范围内分配多个值 [英] Assign multiple values in range
本文介绍了在范围内分配多个值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在VBA中,我可以将数组分配给单元格范围,以便范围内的每个单元格都从数组中获取相应的值:
In VBA I can assign array to range of cells, so that every cell in range gets corresponding value from the array:
Range("A1:D1").Value = Array(1, 2, 3, 4)
我试图对openpyxl做同样的事情:
I was trying to do the same with openpyxl:
import openpyxl
wb = openpyxl.Workbook()
ws = wb.worksheets[0]
ws.range['A1:D1'].value = [1, 2, 3, 4]
但没有成功.
有没有一种方法可以对openpyxl进行范围分配而无需迭代每个单元格?
Is there a way to do range assignment with openpyxl without iterating every cell?
推荐答案
不,不可能,openpyxl中的范围只是一个单元格范围,但是循环很容易(openpyxl 1.8语法)
No, it is not possible, a range in openpyxl is just a range of cells but looping is easy enough (openpyxl 1.8 syntax)
for v,c in zip([1, 2, 3, 4], ws['A1':'D1']):
c.value = v
这篇关于在范围内分配多个值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文