{"id":12336,"date":"2024-03-14T15:36:58","date_gmt":"2024-03-14T15:36:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/"},"modified":"2025-08-05T00:17:56","modified_gmt":"2025-08-05T00:17:56","slug":"how-can-python-read-and-merge-data-from-cells","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/","title":{"rendered":"Python: Read Excel Merged Cells with openpyxl"},"content":{"rendered":"<p>In Python, the openpyxl library can be used to read data from Excel files, including data from merged cells.<\/p>\n<p>Firstly, you need to install the openpyxl library. You can use the pip command to install it:<\/p>\n<pre class=\"post-pre\"><code>pip install openpyxl\r\n<\/code><\/pre>\n<p>Next, you can use the following code to read the data from merged cells:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">from<\/span> openpyxl <span class=\"hljs-keyword\">import<\/span> load_workbook\r\n\r\n<span class=\"hljs-comment\"># \u52a0\u8f7dExcel\u6587\u4ef6<\/span>\r\nworkbook = load_workbook(<span class=\"hljs-string\">'filename.xlsx'<\/span>)\r\n\r\n<span class=\"hljs-comment\"># \u9009\u62e9\u5de5\u4f5c\u8868<\/span>\r\nworksheet = workbook[<span class=\"hljs-string\">'Sheet1'<\/span>]\r\n\r\n<span class=\"hljs-comment\"># \u904d\u5386\u6240\u6709\u5408\u5e76\u5355\u5143\u683c<\/span>\r\n<span class=\"hljs-keyword\">for<\/span> merged_cell <span class=\"hljs-keyword\">in<\/span> worksheet.merged_cells.ranges:\r\n    <span class=\"hljs-comment\"># \u83b7\u53d6\u5408\u5e76\u5355\u5143\u683c\u7684\u8d77\u59cb\u884c\u3001\u8d77\u59cb\u5217\u3001\u7ed3\u675f\u884c\u3001\u7ed3\u675f\u5217<\/span>\r\n    start_row, start_column, end_row, end_column = merged_cell.bounds\r\n\r\n    <span class=\"hljs-comment\"># \u83b7\u53d6\u5408\u5e76\u5355\u5143\u683c\u7684\u503c<\/span>\r\n    merged_cell_value = worksheet.cell(start_row, start_column).value\r\n\r\n    <span class=\"hljs-comment\"># \u6253\u5370\u5408\u5e76\u5355\u5143\u683c\u7684\u503c<\/span>\r\n    <span class=\"hljs-built_in\">print<\/span>(merged_cell_value)\r\n<\/code><\/pre>\n<p>In the code, first use the load_workbook function to load the Excel file. Then, select the worksheet by specifying the worksheet name. Next, use the merged_cells attribute to get all merged cells, and use the bounds method to get the start row, start column, end row, and end column of the merged cells. Finally, use the cell method to get the value of the merged cells.<\/p>\n<p>Note: If the merged cell spans multiple rows or columns, you can handle it according to your needs.<\/p>\n<p>I hope this helps you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Python, the openpyxl library can be used to read data from Excel files, including data from merged cells. Firstly, you need to install the openpyxl library. You can use the pip command to install it: pip install openpyxl Next, you can use the following code to read the data from merged cells: from openpyxl [&hellip;]<\/p>\n","protected":false},"author":12,"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":[10592,9119,16123,1132,16122],"class_list":["post-12336","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-data-reading","tag-excel-automation","tag-merged-cells","tag-openpyxl","tag-python-excel"],"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>Python: Read Excel Merged Cells with openpyxl - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to read data from merged Excel cells in Python using openpyxl. Simple install guide &amp; code included.\" \/>\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-can-python-read-and-merge-data-from-cells\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python: Read Excel Merged Cells with openpyxl\" \/>\n<meta property=\"og:description\" content=\"Learn to read data from merged Excel cells in Python using openpyxl. Simple install guide &amp; code included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/\" \/>\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-14T15:36:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T00:17:56+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\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=\"Liam\" \/>\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-can-python-read-and-merge-data-from-cells\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Python: Read Excel Merged Cells with openpyxl\",\"datePublished\":\"2024-03-14T15:36:58+00:00\",\"dateModified\":\"2025-08-05T00:17:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/\"},\"wordCount\":148,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"data reading\",\"Excel automation\",\"merged cells\",\"openpyxl\",\"Python Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/\",\"name\":\"Python: Read Excel Merged Cells with openpyxl - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T15:36:58+00:00\",\"dateModified\":\"2025-08-05T00:17:56+00:00\",\"description\":\"Learn to read data from merged Excel cells in Python using openpyxl. Simple install guide & code included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python: Read Excel Merged Cells 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\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Python: Read Excel Merged Cells with openpyxl - Blog - Silicon Cloud","description":"Learn to read data from merged Excel cells in Python using openpyxl. Simple install guide & code included.","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-can-python-read-and-merge-data-from-cells\/","og_locale":"en_US","og_type":"article","og_title":"Python: Read Excel Merged Cells with openpyxl","og_description":"Learn to read data from merged Excel cells in Python using openpyxl. Simple install guide & code included.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T15:36:58+00:00","article_modified_time":"2025-08-05T00:17:56+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Python: Read Excel Merged Cells with openpyxl","datePublished":"2024-03-14T15:36:58+00:00","dateModified":"2025-08-05T00:17:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/"},"wordCount":148,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["data reading","Excel automation","merged cells","openpyxl","Python Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/","name":"Python: Read Excel Merged Cells with openpyxl - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T15:36:58+00:00","dateModified":"2025-08-05T00:17:56+00:00","description":"Learn to read data from merged Excel cells in Python using openpyxl. Simple install guide & code included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-python-read-and-merge-data-from-cells\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Python: Read Excel Merged Cells 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\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12336","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12336"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12336\/revisions"}],"predecessor-version":[{"id":156126,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12336\/revisions\/156126"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}