{"id":9836,"date":"2023-12-26T23:43:10","date_gmt":"2023-12-26T20:13:10","guid":{"rendered":"https:\/\/rasanegar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/"},"modified":"2023-12-26T23:43:10","modified_gmt":"2023-12-26T20:13:10","slug":"%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af","status":"publish","type":"post","link":"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/","title":{"rendered":"\u0631\u0641\u0639 \u062e\u0637\u0627\u06cc &#8220;xlrd.biffh.XLRDError: \u0641\u0627\u06cc\u0644 xlsx Excel\u061b \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0646\u0645\u06cc \u0634\u0648\u062f&#8221;"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0633\u0631\u0641\u0635\u0644\u0647\u0627\u06cc \u0645\u0637\u0644\u0628<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/#%d9%85%d8%b9%d8%b1%d9%81%db%8c\" >\u0645\u0639\u0631\u0641\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/#%d8%ae%d8%b7%d8%a7%db%8c_%e2%80%9cxlrdbiffhxlrderror%e2%80%9d_%da%86%db%8c%d8%b3%d8%aa%d8%9f\" >\u062e\u0637\u0627\u06cc &#8220;xlrd.biffh.XLRDError&#8221; \u0686\u06cc\u0633\u062a\u061f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/#%d8%b9%d9%84%d8%aa_%d8%ae%d8%b7%d8%a7\" >\u0639\u0644\u062a \u062e\u0637\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/#%da%86%da%af%d9%88%d9%86%d9%87_%d8%ae%d8%b7%d8%a7_%d8%b1%d8%a7_%d8%b1%d9%81%d8%b9_%da%a9%d9%86%db%8c%d9%85\" >\u0686\u06af\u0648\u0646\u0647 \u062e\u0637\u0627 \u0631\u0627 \u0631\u0641\u0639 \u06a9\u0646\u06cc\u0645<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%81%d8%b9-%d8%ae%d8%b7%d8%a7%db%8c-xlrd-biffh-xlrderror-%d9%81%d8%a7%db%8c%d9%84-xlsx-excel%d8%9b-%d9%be%d8%b4%d8%aa%db%8c%d8%a8%d8%a7%d9%86%db%8c-%d9%86%d9%85%db%8c-%d8%b4%d9%88%d8%af\/#%d9%86%d8%aa%db%8c%d8%ac%d9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span><p> <br \/>\n<\/p>\n<div class=\"mt-8 content\"><noscript><\/p>\n<style>.lazyload-placeholder { display: none;  }<\/style>\n<p><\/noscript><\/p>\n<h2 id=\"introduction\"><span class=\"ez-toc-section\" id=\"%d9%85%d8%b9%d8%b1%d9%81%db%8c\"><\/span>\u0645\u0639\u0631\u0641\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u067e\u0627\u06cc\u062a\u0648\u0646 \u062f\u0627\u0631\u0627\u06cc \u0627\u06a9\u0648\u0633\u06cc\u0633\u062a\u0645 \u063a\u0646\u06cc \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627 \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0632\u0628\u0627\u0646\u06cc \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u062f.  \u06cc\u06a9\u06cc \u0627\u0632 \u0622\u0646 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627 \u0627\u0633\u062a <code>pandas<\/code>\u060c \u06a9\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u0646\u0648\u0634\u062a\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631\u0648\u0646 \u062d\u0627\u0641\u0638\u0647 \u0648 \u0641\u0631\u0645\u062a \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0641\u0627\u06cc\u0644 \u0633\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0647\u0646\u06af\u0627\u0645 \u06a9\u0627\u0631 \u0628\u0627 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>pandas.read_excel<\/code>\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0627 \u062e\u0637\u0627\u06cc\u06cc \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0645\u0648\u0627\u062c\u0647 \u0634\u0648\u06cc\u062f:<\/p>\n<pre><code class=\"hljs\">xlrd.biffh.XLRDError: Excel xlsx file; not supported\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0628\u0627\u06cc\u062a\u060c \u0627\u06cc\u0646 \u067e\u06cc\u063a\u0627\u0645 \u062e\u0637\u0627 \u0631\u0627 \u062a\u0634\u0631\u06cc\u062d \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645\u060c \u0645\u06cc\u200c\u0641\u0647\u0645\u06cc\u0645 \u06a9\u0647 \u0686\u0631\u0627 \u0631\u062e \u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u0646\u062d\u0648\u0647 \u0631\u0641\u0639 \u0622\u0646 \u0631\u0627 \u06cc\u0627\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u0645.<\/p>\n<h2 id=\"whatistheerrorxlrdbiffhxlrderror\"><span class=\"ez-toc-section\" id=\"%d8%ae%d8%b7%d8%a7%db%8c_%e2%80%9cxlrdbiffhxlrderror%e2%80%9d_%da%86%db%8c%d8%b3%d8%aa%d8%9f\"><\/span>\u062e\u0637\u0627\u06cc &#8220;xlrd.biffh.XLRDError&#8221; \u0686\u06cc\u0633\u062a\u061f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06cc\u0646 <code>xlrd.biffh.XLRDError<\/code> \u067e\u06cc\u0627\u0645 \u062e\u0637\u0627\u06cc \u062e\u0627\u0635\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 \u062d\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627 \u0622\u0646 \u0628\u0627 \u0622\u0646 \u0645\u0648\u0627\u062c\u0647 \u0634\u0648\u06cc\u062f <code>pandas<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646  \u0627\u06cc\u0646 \u062e\u0637\u0627 \u0632\u0645\u0627\u0646\u06cc \u0631\u062e \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f <code>.xlsx<\/code> \u067e\u0633\u0648\u0646\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>pandas.read_excel<\/code> \u0631\u0648\u0634.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u06cc\u06a9 \u0645\u062b\u0627\u0644 \u0627\u0632 \u062e\u0637\u0627 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">import<\/span> pandas <span class=\"hljs-keyword\">as<\/span> pd\n\ndf = pd.read_excel(<span class=\"hljs-string\">'file.xlsx'<\/span>)\n<\/code><\/pre>\n<p>\u062e\u0631\u0648\u062c\u06cc:<\/p>\n<pre><code class=\"hljs\">xlrd.biffh.XLRDError: Excel xlsx file; not supported\n<\/code><\/pre>\n<h2 id=\"causeoftheerror\"><span class=\"ez-toc-section\" id=\"%d8%b9%d9%84%d8%aa_%d8%ae%d8%b7%d8%a7\"><\/span>\u0639\u0644\u062a \u062e\u0637\u0627<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06cc\u0646 <code>xlrd.biffh.XLRDError<\/code> \u062e\u0637\u0627 \u0646\u0627\u0634\u06cc \u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631 \u0627\u062e\u06cc\u0631 \u062f\u0631 <code>xlrd<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0627\u06cc \u06a9\u0647 <code>pandas<\/code> \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u06cc\u0646 <code>xlrd<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0627\u06a9\u0646\u0648\u0646 \u0641\u0642\u0637 \u0642\u062f\u06cc\u0645\u06cc \u062a\u0631 \u0631\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f <code>.xls<\/code> \u0641\u0631\u0645\u062a \u0641\u0627\u06cc\u0644 \u0648 \u062f\u06cc\u06af\u0631 \u0627\u0632 \u062c\u062f\u06cc\u062f\u062a\u0631 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0646\u0645\u06cc \u06a9\u0646\u062f <code>.xlsx<\/code> \u0641\u0631\u0645\u062a \u0641\u0627\u06cc\u0644.<\/p>\n<p>\u0627\u06af\u0631 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f\u060c \u0627\u06cc\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06a9\u0645\u06cc \u062a\u0639\u062c\u0628 \u0622\u0648\u0631 \u0628\u0627\u0634\u062f <code>pandas.read_excel<\/code> \u0628\u0627 <code>xlrd<\/code>.  \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u06cc\u0634 \u0641\u0631\u0636\u060c <code>pandas.read_excel<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>xlrd<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644\u060c \u0627\u0645\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 <code>xlrd<\/code> \u0646\u0633\u062e\u0647 2.0.0\u060c \u0627\u06cc\u0646 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 <a target=\"_blank\" rel=\"nofollow noopener\" href=\"https:\/\/github.com\/python-excel\/xlrd\/commits\/master\">\u062f\u06cc\u06af\u0631 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0646\u0645\u06cc \u06a9\u0646\u062f<\/a> <code>.xlsx<\/code>  \u0641\u0627\u06cc\u0644 \u0647\u0627.<\/p>\n<\/p>\n<div data-nosnippet=\"\" id=\"newsletter\">\n<div class=\"bg-gray-100 border rounded my-8\">\n<div class=\"py-3 px-3 sm:px-4 lg:py-6 lg:px-6\">\n<div class=\"text-center\"><span class=\"text-xl font-extrabold tracking-tight text-gray-600 sm:text-2xl\">\u062f\u0648\u0631\u0647 \u0647\u0627\u06cc \u0631\u0627\u06cc\u06af\u0627\u0646\u060c \u067e\u0631\u0648\u0698\u0647 \u0647\u0627\u06cc \u0647\u062f\u0627\u06cc\u062a \u0634\u062f\u0647 \u0648 \u0645\u0648\u0627\u0631\u062f \u062f\u06cc\u06af\u0631 \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0646\u06cc\u062f<\/span><\/div>\n<div class=\"mt-4\">\n<div class=\"flex justify-center\">\n<div class=\"flex-grow flex-col justify-center\">\n<form class=\"group sm:flex sm:justify-center\"><label for=\"email-address\" class=\"sr-only\">\u0622\u062f\u0631\u0633 \u0627\u06cc\u0645\u06cc\u0644<\/label><input id=\"email-address\" name=\"email-address\" type=\"email\" autocomplete=\"email\" required=\"\" class=\"flex-1 w-full sm:max-w-md px-5 py-3 border sm:border-r-0 border-gray-400 placeholder-gray-500 rounded-md sm:rounded-r-none sm:rounded-l-md focus:ring-0 focus:border-gray-900\" placeholder=\"Enter your email\" value=\"\"><\/p>\n<div class=\"mt-3 sm:mt-0 sm:flex-shrink-0\"><button type=\"submit\" class=\"w-full flex items-center justify-center px-5 py-3 rounded-md sm:rounded-l-none sm:rounded-r-md shadow border border-transparent text-base font-medium text-white bg-orange-500 hover:bg-orange-600\">\u0627\u0634\u062a\u0631\u0627\u06a9 \u062f\u0631<\/button><\/div>\n<\/form>\n<p class=\"text-center mt-3 text-sm text-gray-500\">\u0628\u062f\u0648\u0646 \u0647\u0631\u0632\u0646\u0627\u0645\u0647 \u0647\u0631\u06af\u0632.  \u0644\u063a\u0648 \u0627\u0634\u062a\u0631\u0627\u06a9 \u062f\u0631 \u0647\u0631 \u0632\u0645\u0627\u0646.  \u0645\u0627 \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<!-- --> \u0633\u06cc\u0627\u0633\u062a \u062d\u0641\u0638 \u062d\u0631\u06cc\u0645 \u062e\u0635\u0648\u0635\u06cc.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703621589_720_fix-error-xlrd-biffh-xlrderror-excel-xlsx-file-not-supported-1.png\" alt=\"\" title=\"\"><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703621590_652_fix-error-xlrd-biffh-xlrderror-excel-xlsx-file-not-supported-2.png\" alt=\"\" title=\"\"><br \/>\n<small>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646\u060c \u0647\u0645\u0647 \u0645\u0627 \u0622\u0646\u062c\u0627 \u0628\u0648\u062f\u0647 \u0627\u06cc\u0645&#8230;<\/small><\/p>\n<h2 id=\"howtofixtheerror\"><span class=\"ez-toc-section\" id=\"%da%86%da%af%d9%88%d9%86%d9%87_%d8%ae%d8%b7%d8%a7_%d8%b1%d8%a7_%d8%b1%d9%81%d8%b9_%da%a9%d9%86%db%8c%d9%85\"><\/span>\u0686\u06af\u0648\u0646\u0647 \u062e\u0637\u0627 \u0631\u0627 \u0631\u0641\u0639 \u06a9\u0646\u06cc\u0645<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0631\u0627\u0647 \u062d\u0644 \u0627\u06cc\u0646 \u062e\u0637\u0627 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a.  \u0641\u0642\u0637 \u0628\u0627\u06cc\u062f \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f <code>openpyxl<\/code> \u0648 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f <code>engine<\/code> \u0627\u0633\u062a\u062f\u0644\u0627\u0644 \u062f\u0631 <code>pandas.read_excel<\/code> \u0631\u0648\u0634 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>openpyxl<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0628\u0647 \u062c\u0627\u06cc <code>xlrd<\/code>.  \u0627\u06cc\u0646 <code>openpyxl<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0631 \u062f\u0648 \u0631\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f <code>.xls<\/code> \u0648 <code>.xlsx<\/code> \u0641\u0631\u0645\u062a \u0647\u0627\u06cc \u0641\u0627\u06cc\u0644<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0646\u062d\u0648\u0647 \u0627\u0646\u062c\u0627\u0645 \u0622\u0646 \u0622\u0645\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f <code>openpyxl<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647  \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 pip \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> pip install openpyxl<\/span>\n<\/code><\/pre>\n<p>\u0633\u067e\u0633\u060c \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f <code>engine<\/code> \u0627\u0633\u062a\u062f\u0644\u0627\u0644 \u062f\u0631 <code>pandas.read_excel<\/code> \u0631\u0648\u0634\u06cc \u0645\u0627\u0646\u0646\u062f \u0627\u06cc\u0646:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">import<\/span> pandas <span class=\"hljs-keyword\">as<\/span> pd\n\ndf = pd.read_excel(<span class=\"hljs-string\">'file.xlsx'<\/span>, engine=<span class=\"hljs-string\">'openpyxl'<\/span>)\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 \u06a9\u062f \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>openpyxl<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647\u060c \u0648 \u062f\u06cc\u06af\u0631 \u0628\u0627 \u0622\u0646 \u0645\u0648\u0627\u062c\u0647 \u0646\u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u062f <code>xlrd.biffh.XLRDError<\/code> \u062e\u0637\u0627<\/p>\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\"><\/span>\u0646\u062a\u06cc\u062c\u0647<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0628\u0627\u06cc\u062a\u060c \u0645\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f <code>xlrd.biffh.XLRDError<\/code> \u062e\u0637\u0627\u06cc\u06cc \u06a9\u0647 \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0631\u062e \u0645\u06cc \u062f\u0647\u062f <code>pandas.read_excel<\/code> \u062e\u0648\u0627\u0646\u062f\u0646 <code>.xlsx<\/code> \u0641\u0627\u06cc\u0644 \u0647\u0627.  \u0645\u0627 \u06cc\u0627\u062f \u06af\u0631\u0641\u062a\u06cc\u0645 \u06a9\u0647 \u0686\u0631\u0627 \u0627\u06cc\u0646 \u062e\u0637\u0627 \u0631\u062e \u0645\u06cc \u062f\u0647\u062f \u0648 \u0686\u06af\u0648\u0646\u0647 \u0622\u0646 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0637\u0631\u0641 \u06a9\u0646\u06cc\u0645 <code>openpyxl<\/code> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647<\/p>\n<\/div>\n<p><br \/>\n<br \/>\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 1402-12-26 23:43:04<br \/>\n<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;9836&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628&quot;,&quot;legend&quot;:&quot;0\\\/5 (0 \u0631\u0627\u06cc)&quot;,&quot;size&quot;:&quot;30&quot;,&quot;title&quot;:&quot;\u0631\u0641\u0639 \u062e\u0637\u0627\u06cc \\u0026quot;xlrd.biffh.XLRDError: \u0641\u0627\u06cc\u0644 xlsx Excel\u061b \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0646\u0645\u06cc \u0634\u0648\u062f\\u0026quot;&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} ({count} \u0631\u0627\u06cc)&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 24px;\">\n            <span class=\"kksr-muted\">\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 2<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span>\u0645\u0639\u0631\u0641\u06cc \u067e\u0627\u06cc\u062a\u0648\u0646 \u062f\u0627\u0631\u0627\u06cc \u0627\u06a9\u0648\u0633\u06cc\u0633\u062a\u0645 \u063a\u0646\u06cc \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627 \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0632\u0628\u0627\u0646\u06cc \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u062f. \u06cc\u06a9\u06cc \u0627\u0632 \u0622\u0646 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627 \u0627\u0633\u062a pandas\u060c \u06a9\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u0646\u0648\u0634\u062a\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631\u0648\u0646 \u062d\u0627\u0641\u0638\u0647 \u0648 \u0641\u0631\u0645\u062a \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0641\u0627\u06cc\u0644 \u0633\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0627 \u0627\u06cc\u0646 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":9837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1772,620],"tags":[2350,2510,2509,2352,2508,1840,1844,1744,1851,1103,2172,2317,1859,2342,2264,1901,2322,2511],"class_list":["post-9836","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-javascript","category-programming","tag-2350","tag-excel","tag-xlrd-biffh-xlrderror","tag-xlsx","tag--javascript","tag-1840","tag-1844","tag-1744","tag-1851","tag-1103","tag-2172","tag-2317","tag---nodejs","tag-2342","tag-2264","tag-1901","tag-2322","tag-2511"],"acf":[],"_links":{"self":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/9836","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/comments?post=9836"}],"version-history":[{"count":0,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/9836\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media\/9837"}],"wp:attachment":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media?parent=9836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/categories?post=9836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/tags?post=9836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}