{"id":9891,"date":"2024-03-14T10:18:06","date_gmt":"2024-03-14T10:18:06","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/"},"modified":"2024-03-20T16:35:31","modified_gmt":"2024-03-20T16:35:31","slug":"how-can-php-extract-data-from-an-excel-file","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/","title":{"rendered":"How can PHP extract data from an Excel file?"},"content":{"rendered":"<p>PHP can utilize the PHPExcel library to retrieve data from Excel files. Below is a simple example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">require<\/span> <span class=\"hljs-string\">'PHPExcel\/IOFactory.php'<\/span>;\r\n\r\n<span class=\"hljs-variable\">$inputFileName<\/span> = <span class=\"hljs-string\">'example.xlsx'<\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ \u8bfb\u53d6Excel\u6587\u4ef6<\/span>\r\n<span class=\"hljs-variable\">$objPHPExcel<\/span> = <span class=\"hljs-title class_\">PHPExcel_IOFactory<\/span>::<span class=\"hljs-title function_ invoke__\">load<\/span>(<span class=\"hljs-variable\">$inputFileName<\/span>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u83b7\u53d6\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868<\/span>\r\n<span class=\"hljs-variable\">$sheet<\/span> = <span class=\"hljs-variable\">$objPHPExcel<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">getSheet<\/span>(<span class=\"hljs-number\">0<\/span>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u83b7\u53d6\u6700\u5927\u884c\u6570\u548c\u5217\u6570<\/span>\r\n<span class=\"hljs-variable\">$highestRow<\/span> = <span class=\"hljs-variable\">$sheet<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">getHighestRow<\/span>();\r\n<span class=\"hljs-variable\">$highestColumn<\/span> = <span class=\"hljs-variable\">$sheet<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">getHighestColumn<\/span>();\r\n\r\n<span class=\"hljs-comment\">\/\/ \u9010\u884c\u8bfb\u53d6\u6570\u636e<\/span>\r\n<span class=\"hljs-keyword\">for<\/span> (<span class=\"hljs-variable\">$row<\/span> = <span class=\"hljs-number\">1<\/span>; <span class=\"hljs-variable\">$row<\/span> &lt;= <span class=\"hljs-variable\">$highestRow<\/span>; <span class=\"hljs-variable\">$row<\/span>++) {\r\n    <span class=\"hljs-variable\">$rowData<\/span> = <span class=\"hljs-variable\">$sheet<\/span>-&gt;<span class=\"hljs-title function_ invoke__\">rangeToArray<\/span>(<span class=\"hljs-string\">'A'<\/span> . <span class=\"hljs-variable\">$row<\/span> . <span class=\"hljs-string\">':'<\/span> . <span class=\"hljs-variable\">$highestColumn<\/span> . <span class=\"hljs-variable\">$row<\/span>, <span class=\"hljs-literal\">NULL<\/span>, <span class=\"hljs-literal\">TRUE<\/span>, <span class=\"hljs-literal\">FALSE<\/span>);\r\n    <span class=\"hljs-title function_ invoke__\">print_r<\/span>(<span class=\"hljs-variable\">$rowData<\/span>);\r\n}\r\n<\/code><\/pre>\n<p>In the example above, &#8220;example.xlsx&#8221; is the name of the Excel file to be read. Start by using the PHPExcel_IOFactory::load method to load the Excel file, then retrieve the first worksheet and get the maximum number of rows and columns. Finally, use the rangeToArray method to read the data row by row and output it to the console. You can further process and manipulate the Excel data as needed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PHP can utilize the PHPExcel library to retrieve data from Excel files. Below is a simple example code: require &#8216;PHPExcel\/IOFactory.php&#8217;; $inputFileName = &#8216;example.xlsx&#8217;; \/\/ \u8bfb\u53d6Excel\u6587\u4ef6 $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); \/\/ \u83b7\u53d6\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868 $sheet = $objPHPExcel-&gt;getSheet(0); \/\/ \u83b7\u53d6\u6700\u5927\u884c\u6570\u548c\u5217\u6570 $highestRow = $sheet-&gt;getHighestRow(); $highestColumn = $sheet-&gt;getHighestColumn(); \/\/ \u9010\u884c\u8bfb\u53d6\u6570\u636e for ($row = 1; $row &lt;= $highestRow; $row++) { $rowData = $sheet-&gt;rangeToArray(&#8216;A&#8217; [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-9891","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"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>How can PHP extract data from an Excel file? - Blog - Silicon Cloud<\/title>\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-php-extract-data-from-an-excel-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can PHP extract data from an Excel file?\" \/>\n<meta property=\"og:description\" content=\"PHP can utilize the PHPExcel library to retrieve data from Excel files. Below is a simple example code: require &#039;PHPExcel\/IOFactory.php&#039;; $inputFileName = &#039;example.xlsx&#039;; \/\/ \u8bfb\u53d6Excel\u6587\u4ef6 $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); \/\/ \u83b7\u53d6\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868 $sheet = $objPHPExcel-&gt;getSheet(0); \/\/ \u83b7\u53d6\u6700\u5927\u884c\u6570\u548c\u5217\u6570 $highestRow = $sheet-&gt;getHighestRow(); $highestColumn = $sheet-&gt;getHighestColumn(); \/\/ \u9010\u884c\u8bfb\u53d6\u6570\u636e for ($row = 1; $row &lt;= $highestRow; $row++) { $rowData = $sheet-&gt;rangeToArray(&#039;A&#039; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/\" \/>\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-14T10:18:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-20T16:35:31+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\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=\"William Carter\" \/>\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-php-extract-data-from-an-excel-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How can PHP extract data from an Excel file?\",\"datePublished\":\"2024-03-14T10:18:06+00:00\",\"dateModified\":\"2024-03-20T16:35:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/\"},\"wordCount\":99,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/\",\"name\":\"How can PHP extract data from an Excel file? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T10:18:06+00:00\",\"dateModified\":\"2024-03-20T16:35:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can PHP extract data from an Excel file?\"}]},{\"@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\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can PHP extract data from an Excel file? - Blog - Silicon Cloud","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-php-extract-data-from-an-excel-file\/","og_locale":"en_US","og_type":"article","og_title":"How can PHP extract data from an Excel file?","og_description":"PHP can utilize the PHPExcel library to retrieve data from Excel files. Below is a simple example code: require 'PHPExcel\/IOFactory.php'; $inputFileName = 'example.xlsx'; \/\/ \u8bfb\u53d6Excel\u6587\u4ef6 $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); \/\/ \u83b7\u53d6\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868 $sheet = $objPHPExcel-&gt;getSheet(0); \/\/ \u83b7\u53d6\u6700\u5927\u884c\u6570\u548c\u5217\u6570 $highestRow = $sheet-&gt;getHighestRow(); $highestColumn = $sheet-&gt;getHighestColumn(); \/\/ \u9010\u884c\u8bfb\u53d6\u6570\u636e for ($row = 1; $row &lt;= $highestRow; $row++) { $rowData = $sheet-&gt;rangeToArray('A' [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T10:18:06+00:00","article_modified_time":"2024-03-20T16:35:31+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How can PHP extract data from an Excel file?","datePublished":"2024-03-14T10:18:06+00:00","dateModified":"2024-03-20T16:35:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/"},"wordCount":99,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/","name":"How can PHP extract data from an Excel file? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T10:18:06+00:00","dateModified":"2024-03-20T16:35:31+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-php-extract-data-from-an-excel-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can PHP extract data from an Excel file?"}]},{"@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\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9891","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=9891"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9891\/revisions"}],"predecessor-version":[{"id":43090,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9891\/revisions\/43090"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=9891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=9891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=9891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}