有一种方法来写在单元格垂直通过xlwings?

Question

我想垂直组织(拆分)的结果这个

不是这个

import xlwings as xw
wb = xw.Book()
ws = wb.sheets.active
result = "1,2,3,4,5,6,7"
ws.range(1,1).value = result.split(",")

Answer 1

xlwings教程说:

在Excel中使用transpose:

sht.range('A1').options(transpose=True).value = [1,2,3,4]