{"id":13290,"date":"2024-03-15T06:47:27","date_gmt":"2024-03-15T06:47:27","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/"},"modified":"2025-08-05T15:47:54","modified_gmt":"2025-08-05T15:47:54","slug":"how-to-loop-through-writing-data-with-openpyxl","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/","title":{"rendered":"Loop &#038; Write Excel Data with openpyxl"},"content":{"rendered":"<p>You can loop through rows in an Excel spreadsheet using the iter_rows() method from the openpyxl module and write data using the cell() method. Here&#8217;s an example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">from<\/span> openpyxl <span class=\"hljs-keyword\">import<\/span> Workbook\r\n\r\n<span class=\"hljs-comment\"># \u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u5de5\u4f5c\u7c3f<\/span>\r\nworkbook = Workbook()\r\n\r\n<span class=\"hljs-comment\"># \u9009\u62e9\u6d3b\u52a8\u7684\u5de5\u4f5c\u8868<\/span>\r\nsheet = workbook.active\r\n\r\n<span class=\"hljs-comment\"># \u521b\u5efa\u8981\u5199\u5165\u7684\u6570\u636e\u5217\u8868<\/span>\r\ndata = [[<span class=\"hljs-string\">'\u59d3\u540d'<\/span>, <span class=\"hljs-string\">'\u5e74\u9f84'<\/span>, <span class=\"hljs-string\">'\u6027\u522b'<\/span>],\r\n        [<span class=\"hljs-string\">'\u5f20\u4e09'<\/span>, <span class=\"hljs-number\">20<\/span>, <span class=\"hljs-string\">'\u7537'<\/span>],\r\n        [<span class=\"hljs-string\">'\u674e\u56db'<\/span>, <span class=\"hljs-number\">25<\/span>, <span class=\"hljs-string\">'\u7537'<\/span>],\r\n        [<span class=\"hljs-string\">'\u738b\u4e94'<\/span>, <span class=\"hljs-number\">30<\/span>, <span class=\"hljs-string\">'\u5973'<\/span>]]\r\n\r\n<span class=\"hljs-comment\"># \u5faa\u73af\u904d\u5386\u6570\u636e\u5217\u8868\uff0c\u5e76\u5c06\u6570\u636e\u5199\u5165\u5355\u5143\u683c<\/span>\r\n<span class=\"hljs-keyword\">for<\/span> row <span class=\"hljs-keyword\">in<\/span> data:\r\n    sheet.append(row)\r\n\r\n<span class=\"hljs-comment\"># \u4fdd\u5b58\u5de5\u4f5c\u7c3f<\/span>\r\nworkbook.save(<span class=\"hljs-string\">\"data.xlsx\"<\/span>)\r\n<\/code><\/pre>\n<p>In the above example, we start by creating a new workbook and selecting the active worksheet. Next, we create a list containing the data to be written. Then, we use the append() method to iterate through the data list and write each row of data to cells in the worksheet. Finally, we save the workbook to a file named &#8220;data.xlsx&#8221;.<\/p>\n<p>I hope this helps you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can loop through rows in an Excel spreadsheet using the iter_rows() method from the openpyxl module and write data using the cell() method. Here&#8217;s an example: from openpyxl import Workbook # \u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u5de5\u4f5c\u7c3f workbook = Workbook() # \u9009\u62e9\u6d3b\u52a8\u7684\u5de5\u4f5c\u8868 sheet = workbook.active # \u521b\u5efa\u8981\u5199\u5165\u7684\u6570\u636e\u5217\u8868 data = [[&#8216;\u59d3\u540d&#8217;, &#8216;\u5e74\u9f84&#8217;, &#8216;\u6027\u522b&#8217;], [&#8216;\u5f20\u4e09&#8217;, 20, &#8216;\u7537&#8217;], [&#8216;\u674e\u56db&#8217;, 25, &#8216;\u7537&#8217;], [&#8216;\u738b\u4e94&#8217;, [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[9119,17678,1132,16122,16733],"class_list":["post-13290","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-excel-automation","tag-iter_rows","tag-openpyxl","tag-python-excel","tag-write-data"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Loop &amp; Write Excel Data with openpyxl - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Master looping through Excel rows and writing data using Python&#039;s openpyxl with practical code examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Loop &amp; Write Excel Data with openpyxl\" \/>\n<meta property=\"og:description\" content=\"Master looping through Excel rows and writing data using Python&#039;s openpyxl with practical code examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T06:47:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T15:47:54+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"Loop &#038; Write Excel Data with openpyxl\",\"datePublished\":\"2024-03-15T06:47:27+00:00\",\"dateModified\":\"2025-08-05T15:47:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\"},\"wordCount\":101,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Excel automation\",\"iter_rows\",\"openpyxl\",\"Python Excel\",\"Write Data\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\",\"name\":\"Loop & Write Excel Data with openpyxl - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T06:47:27+00:00\",\"dateModified\":\"2025-08-05T15:47:54+00:00\",\"description\":\"Master looping through Excel rows and writing data using Python's openpyxl with practical code examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Loop &#038; Write Excel Data with openpyxl\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Loop & Write Excel Data with openpyxl - Blog - Silicon Cloud","description":"Master looping through Excel rows and writing data using Python's openpyxl with practical code examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/","og_locale":"en_US","og_type":"article","og_title":"Loop & Write Excel Data with openpyxl","og_description":"Master looping through Excel rows and writing data using Python's openpyxl with practical code examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T06:47:27+00:00","article_modified_time":"2025-08-05T15:47:54+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"Loop &#038; Write Excel Data with openpyxl","datePublished":"2024-03-15T06:47:27+00:00","dateModified":"2025-08-05T15:47:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/"},"wordCount":101,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Excel automation","iter_rows","openpyxl","Python Excel","Write Data"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/","name":"Loop & Write Excel Data with openpyxl - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T06:47:27+00:00","dateModified":"2025-08-05T15:47:54+00:00","description":"Master looping through Excel rows and writing data using Python's openpyxl with practical code examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-loop-through-writing-data-with-openpyxl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Loop &#038; Write Excel Data with openpyxl"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13290"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13290\/revisions"}],"predecessor-version":[{"id":157243,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13290\/revisions\/157243"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}