Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

is there a way to write in cells vertically via xlwings?

Tags:

python

xlwings

I want to organize the (split)ed result vertically like this

not this

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(",")
like image 805
Junghoon Kim Avatar asked Oct 14 '25 08:10

Junghoon Kim


1 Answers

The xlwings tutorial says:

To write a list in column orientation to Excel, use transpose:

sht.range('A1').options(transpose=True).value = [1,2,3,4]
like image 114
mkrieger1 Avatar answered Oct 16 '25 21:10

mkrieger1



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!