{"id":50,"date":"2026-02-09T11:10:55","date_gmt":"2026-02-09T03:10:55","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=50"},"modified":"2026-01-17T05:45:17","modified_gmt":"2026-01-17T05:45:17","slug":"how-to-write-python-list-data-to-excel-worksheet-using-xlwings","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-write-python-list-data-to-excel-worksheet-using-xlwings\/","title":{"rendered":"How To Write Python List Data to Excel Worksheet Using xlwings?"},"content":{"rendered":"

Method<\/h2>\n

Write rows<\/b><\/h3>\n

#xlwings<\/p>\n

lst=[1,2,3,4,5]<\/p>\n

sht.range(‘A1’).value=lst\u00a0\u00a0\u00a0 #Write Python data to Excel worksheet<\/p>\n

#Or<\/p>\n

#lst=[1,2,3,4,5]<\/p>\n

#sht.range(‘E1’).options(transpose=True).value=lst\u00a0\u00a0\u00a0 #Transpose<\/p>\n

\u00a0<\/p>\n

#xlwings API<\/p>\n

#lst=[[1],[2],[3],[4],[5]]<\/p>\n

#sht.api.Range(‘C1:C5’).Value=lst\u00a0\u00a0\u00a0 #Write directly<\/p>\n

#Or<\/p>\n

#lst=[1,2,3,4,5]<\/p>\n

#sht.api.Range(‘E1:E5’).Value=app.api.WorksheetFunction.Transpose(lst)\u00a0\u00a0\u00a0 #Transpose<\/p>\n

\u00a0<\/p>\n

2D data<\/b><\/h3>\n

#xlwings<\/p>\n

#sht.range(‘A5:B6’).value=[[1,2],[3,4]]<\/p>\n

#sht.range(‘A1′).options(expand=’table’).value=[[1,2],[3,4]]<\/p>\n

\u00a0<\/p>\n

#xlwings API<\/p>\n

#sht.api.Range(‘A5:B6’).Value=[[1,2],[3,4]]<\/p>\n

Sample Code<\/h2>\n\n\n
#Write Python list data to Excel worksheet \n\nimport xlwings as xw    #Import the xlwings package\n\napp=xw.App()\nbk=app.books.active    #Get the active workbook\nsht=bk.sheets.active    #Get the active worksheet \n\n#Write rows\n#xlwings\n#lst=[1,2,3,4,5]\n#sht.range('A1').value=lst    #Write Python data to Excel worksheet\n#Or\n#lst=[1,2,3,4,5]\n#sht.range('E1').options(transpose=True).value=lst    #Transpose\n\n#xlwings API\n#lst=[[1],[2],[3],[4],[5]]\n#sht.api.Range('C1:C5').Value=lst    #Write directly\n#Or\n#lst=[1,2,3,4,5]\n#sht.api.Range('E1:E5').Value=app.api.WorksheetFunction.Transpose(lst)    #Transpose\n\n#2D data\n#xlwings\nsht.range('A5:B6').value=[[1,2],[3,4]]\nsht.range('A1').options(expand='table').value=[[1,2],[3,4]]\n\n#xlwings API\n#sht.api.Range('A5:B6').Value=[[1,2],[3,4]]\n\n#bk.close()\n#app.kill()<\/code><\/pre>\n\n\n\n
\"Write<\/figure>\n","protected":false},"excerpt":{"rendered":"
Method<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-50","post","type-post","status-publish","format-standard","hentry","category-xlwings-data"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=50"}],"version-history":[{"count":3,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":340,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/50\/revisions\/340"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}