찾다
백엔드 개발PHP 튜토리얼PHPExcel 读写封装类_PHP教程
PHPExcel 读写封装类_PHP教程Jul 20, 2016 am 11:15 AM
excelphpexcel할 수 있다캡슐화우리를데이터문서생성하다친절한읽고 쓰기읽다

  对于 excel  文件的的生成于数据读取,我们可以用到 PHPExcel 插件。地址:http://phpexcel.codeplex.com/releases/view/107442 ,选第一个下载。然后解压的文件目录如下:

  初学者应该先去看示例,代码不是很难理解。方法名都是观其名,知其用。在看过些许例子的基础上,我才想到封装一下,用着方便。鉴于我自己也只是入门。所以写了个相对入门的封装。

<span   1</span> <form  method="post" enctype="multipart/form-data" >
<span   2</span> 
<span   3</span> 文件:<input type="file" name="files" /></li>
<span   4</span> <input type="submit" value="提交" />
<span   5</span> </form>
<span   6</span> 
<span   7</span> <?<span php
</span><span   8</span> 
<span   9</span> <span //</span><span set_include_path(get_include_path() . PATH_SEPARATOR . 'Excel/Classes/');</span>
<span  10</span> 
<span  11</span> <span require_once</span> 'Excel/Classes/PHPExcel.php'<span ;
</span><span  12</span> 
<span  13</span> <span class</span> myExcel <span extends</span><span  PHPExcel{
</span><span  14</span>     
<span  15</span>     <span private</span> <span $file</span><span ;
</span><span  16</span>     <span private</span> <span $fileType</span><span ;
</span><span  17</span> 
<span  18</span>     <span private</span> <span $objProperty</span>; <span //</span><span 文档属性对象 </span>
<span  19</span>     <span private</span> <span $objReader</span><span ;
</span><span  20</span>     <span private</span> <span $objWriter</span><span ;
</span><span  21</span>     
<span  22</span>     <span public</span> <span function</span><span  __construct(){
</span><span  23</span>         parent::<span __construct();
</span><span  24</span> 
<span  25</span> <span     }
</span><span  26</span>     
<span  27</span>     <span /*</span> 
<span  28</span> <span      * 设置文档属性
</span><span  29</span> <span      * $property = array('title'=>'标题', 'creator' => '作者'); 
</span><span  30</span>     <span */</span>
<span  31</span>     <span public</span> <span function</span> setProperty(<span $property</span><span ){
</span><span  32</span>         <span $this</span>->objProperty = <span $this</span>-><span getProperties();
</span><span  33</span>         <span if</span>(!<span empty</span>(<span $property</span>['creator']))<span $this</span>->objProperty->setCreator(<span $property</span>['creator'<span ]);
</span><span  34</span>         <span if</span>(!<span empty</span>(<span $property</span>['title'])) <span $this</span>->objProperty->setTitle(<span $property</span>['title'<span ]);
</span><span  35</span>         <span if</span>(!<span empty</span>(<span $property</span>['subject']))<span $this</span>->objProperty->setSubject(<span $property</span>['subject'<span ]);
</span><span  36</span>         <span if</span>(!<span empty</span>(<span $property</span>['laster']))<span $this</span>->objProperty->setLastModifiedBy(<span $property</span>['laster'<span ]);
</span><span  37</span>         <span if</span>(!<span empty</span>(<span $property</span>['description']))<span $this</span>->objProperty->setDescription(<span $property</span>['description'<span ]);
</span><span  38</span>         <span if</span>(!<span empty</span>(<span $property</span>['keyword']))<span $this</span>->objProperty->setKeywords(<span $property</span>['keyword'<span ]);
</span><span  39</span>         <span if</span>(!<span empty</span>(<span $property</span>['category']))<span $this</span>->objProperty->setCategory(<span $property</span>['category'<span ]);
</span><span  40</span> <span     }
</span><span  41</span>     
<span  42</span>     <span /*</span> 
<span  43</span> <span      * 添加数据
</span><span  44</span> <span      * $data = array( 'a1'=>'a111', 'b1'=>'b222', 'c1'=>'c111',); 
</span><span  45</span> <span      * </span><span */</span>
<span  46</span>     <span public</span> <span function</span> addData(<span $data</span>, <span $index</span> = <span null</span><span ){
</span><span  47</span>         <span $objAdd</span> = (<span $index</span>)? <span $this</span>->setActiveSheetIndex(<span $index</span>) : <span $this</span>-><span getActiveSheet();
</span><span  48</span>         <span foreach</span>(<span $data</span> <span as</span> <span $key</span> => <span $val</span><span ){
</span><span  49</span>             <span if</span>(<span empty</span>(<span $key</span>) || <span empty</span>(<span $val</span>)) <span continue</span><span ;
</span><span  50</span>             <span $objAdd</span>->setCellValue(<span $key</span>, <span $val</span><span );
</span><span  51</span> <span         }
</span><span  52</span> <span     }
</span><span  53</span>     
<span  54</span>     <span //</span><span 生成文件</span>
<span  55</span>     <span public</span> <span function</span> saveFile(<span $file</span>, <span $path</span> = <span null</span>, <span $type</span> = 'Excel5'<span ){
</span><span  56</span>         <span $this</span>->objWriter = PHPExcel_IOFactory::createWriter(<span $this</span>, <span $type</span><span );
</span><span  57</span>         
<span  58</span>         <span $filePath</span> = <span $path</span>.<span $file</span><span ;
</span><span  59</span>         <span $this</span>->objWriter->save(<span $filePath</span><span );
</span><span  60</span> <span     }
</span><span  61</span>     
<span  62</span> <span /*</span><span  -------------------------------------- 读取文件 ---------------------------- </span><span */</span>
<span  63</span>     
<span  64</span>     <span //</span><span 设置读对象</span>
<span  65</span>     <span private</span> <span function</span> setReader(<span $file</span>, <span $type</span> = <span null</span><span ){
</span><span  66</span>         <span $this</span>-><span file</span> = <span $file</span><span ;
</span><span  67</span>         <span if</span>(<span $type</span><span ){
</span><span  68</span>             <span $this</span>-><span fileType</span> = <span $type</span><span ;
</span><span  69</span>             <span $this</span>->objReader = PHPExcel_IOFactory::createReader(<span $type</span>)->load(<span $file</span><span );
</span><span  70</span>         }<span else</span><span {
</span><span  71</span>             <span $this</span>-><span fileType</span> = PHPExcel_IOFactory::identify(<span $file</span><span );
</span><span  72</span>             <span $this</span>->objReader = PHPExcel_IOFactory::load(<span $file</span><span );
</span><span  73</span> <span         }
</span><span  74</span> <span     }
</span><span  75</span>     
<span  76</span>     
<span  77</span>     <span //</span><span 加载文件</span>
<span  78</span>     <span public</span> <span function</span> loadFile(<span $file</span>, <span $type</span> = <span null</span><span ){
</span><span  79</span>         <span $this</span>->setReader(<span $file</span>, <span $type</span><span );
</span><span  80</span>         <span $this</span>->sheetData = <span $this</span>->objReader->getActiveSheet()->toArray(<span null</span>,<span true</span>,<span true</span>,<span true</span><span );
</span><span  81</span> <span     }
</span><span  82</span>     
<span  83</span>     <span //</span><span 返回需要的数据</span>
<span  84</span>     <span public</span> <span function</span> dataFormat(<span $meed</span>, <span $start</span> = 1, <span $end</span> = <span null</span><span ){
</span><span  85</span>         <span foreach</span>(<span $this</span>->sheetData <span as</span> <span $line</span> => <span $row</span><span ){
</span><span  86</span>             <span if</span>(<span $start</span> && <span $line</span> < <span $start</span>) <span continue</span><span ;
</span><span  87</span>             <span if</span>(<span $end</span> && <span $line</span> > <span $end</span>) <span break</span><span ;
</span><span  88</span>             <span foreach</span>(<span $row</span> <span as</span> <span $key</span> => <span $val</span><span ){
</span><span  89</span>                 <span if</span>(<span array_key_exists</span>(<span $key</span>, <span $meed</span><span )){
</span><span  90</span>                     <span $data</span>[<span $line</span>][<span $meed</span>[<span $key</span>]] = <span $val</span><span ;
</span><span  91</span> <span                 }
</span><span  92</span> <span             }
</span><span  93</span> <span         }
</span><span  94</span>         <span return</span> <span array_merge</span>(<span $data</span><span );
</span><span  95</span> <span     }
</span><span  96</span>     
<span  97</span>     <span //</span><span 工作表信息</span>
<span  98</span>     <span public</span> <span function</span> sheetInfo(<span $file</span> = <span null</span><span ){
</span><span  99</span>         (<span $file</span>)? <span null</span> : <span $file</span> = <span $this</span>-><span file</span><span ;
</span><span 100</span>         <span $info</span> = <span $this</span>->objReader->listWorksheetInfo(<span $file</span><span );
</span><span 101</span>         <span return</span> <span $info</span><span ;
</span><span 102</span> <span     }
</span><span 103</span>     
<span 104</span> <span }
</span><span 105</span> 
<span 106</span> 
<span 107</span> <span if</span>(<span $_FILES</span><span ){
</span><span 108</span> <span $upDir</span> = './upImg/'<span ;
</span><span 109</span> <span $path</span> = <span $upDir</span>.'aaa.xls'<span ;
</span><span 110</span> <span if</span>(!<span is_dir</span>(<span $upDir</span>)) <span mkdir</span>(<span $upDir</span>, 0777, <span true</span>) or <span exit</span>('上传目录创建失败!'<span );
</span><span 111</span> <span $temp</span> = <span $_FILES</span>['files']['tmp_name'<span ];
</span><span 112</span> <span move_uploaded_file</span>(<span $temp</span>, <span $path</span>);<span //</span><span 移到指定目录</span>
<span 113</span> 
<span 114</span> <span $property</span> = <span array</span><span (
</span><span 115</span>         'title'=>'the title',
<span 116</span>         'creator' => '作者'
<span 117</span> <span );
</span><span 118</span> <span $data</span> = <span array</span><span (
</span><span 119</span>         'A1'=>'a1111',
<span 120</span>         'A2'=>'a222',
<span 121</span>         'B1'=>'b111',
<span 122</span>         'E1'=>'e111',
<span 123</span>         'f2'=>'f22222'
<span 124</span> <span );
</span><span 125</span> 
<span 126</span> <span $data2</span> = <span array</span><span (
</span><span 127</span> 
<span 128</span>         'g2'=>'f22222',
<span 129</span>         'h1'=>'hhh',
<span 130</span>         'j1'=>'jjjjj'
<span 131</span> <span );
</span><span 132</span> 
<span 133</span> <span $test</span> = <span new</span><span  myExcel();
</span><span 134</span> <span //</span><span $test->setProperty($property);
</span><span 135</span> <span //$test->addData($data, 0);
</span><span 136</span> <span //$test->addData($data2);
</span><span 137</span> <span //$test->saveFile('aaa.xls');</span>
<span 138</span> 
<span 139</span> <span $test</span>->loadFile('upImg/aaa.xls'<span );
</span><span 140</span> <span $meed</span> = <span array</span>('A'=>'name','E'=>'age','F'=>'address'<span );
</span><span 141</span> <span $data</span> = <span $test</span>->dataFormat(<span $meed</span>, <span null</span>, 5<span );
</span><span 142</span> <span var_dump</span>(<span $data</span><span );
</span><span 143</span> <span }
</span><span 144</span> ?>

 

数据返回的配置,可以看下图:

 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/440164.htmlTechArticle对于 excel 文件的的生成于数据读取,我们可以用到 PHPExcel 插件。地址:http://phpexcel.codeplex.com/releases/view/107442 ,选第一个下载。然后解压的...
성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
PHP开发:使用 PHPExcel 处理 Excel 文件PHP开发:使用 PHPExcel 处理 Excel 文件Jun 15, 2023 pm 03:45 PM

随着数字化时代的到来,数据已经成为了我们日常生活和工作中最重要的一部分,而Excel文件则成为数据处理的重要工具之一。相信很多PHP开发者也会在工作中经常遇到使用Excel文件进行数据处理和操作的情况。本文将为大家介绍使用PHPExcel库来处理Excel文件的方法和注意事项。什么是PHPExcel?PHPExcel是一个PHP类

完全指南:如何使用php扩展PHPExcel处理Excel文件完全指南:如何使用php扩展PHPExcel处理Excel文件Jul 28, 2023 pm 10:01 PM

完全指南:如何使用PHP扩展PHPExcel处理Excel文件引言:在处理大量数据和统计分析时,Excel文件经常被用作数据存储和交换的一种常见格式。使用PHP扩展PHPExcel,我们可以轻松地读取、写入和修改Excel文件,从而有效地处理Excel数据。本文将介绍如何使用PHP扩展PHPExcel来处理Excel文件,并提供代码示例。一、安装PHPExc

Vue中Axios封装及其常用方法介绍Vue中Axios封装及其常用方法介绍Jun 09, 2023 pm 04:13 PM

Vue中Axios封装及其常用方法介绍Axios是一款基于Promise实现的HTTP库,它的优点在于具有良好的可读性、易用性以及可扩展性。Vue作为一款流行的前端框架,也对Axios提供了全面支持。本文将介绍如何在Vue中进行Axios封装,并且介绍Axios常用的一些方法。一、Axios封装在开发过程中,我们常常需要对Axios进行一些自定义的封装,例如

PHP中的封装技术及应用PHP中的封装技术及应用Oct 12, 2023 pm 01:43 PM

PHP中的封装技术及应用封装是面向对象编程中的一个重要概念,它指的是将数据和对数据的操作封装在一起,以便提供对外部程序的统一访问接口。在PHP中,封装可以通过访问控制修饰符和类的定义来实现。本文将介绍PHP中的封装技术及其应用场景,并提供一些具体的代码示例。一、封装的访问控制修饰符在PHP中,封装主要通过访问控制修饰符来实现。PHP提供了三个访问控制修饰符,

如何使用 PHP 实现数据缓存和读写功能如何使用 PHP 实现数据缓存和读写功能Sep 05, 2023 pm 05:45 PM

如何使用PHP实现数据缓存和读写功能缓存是提高系统性能的一种重要方式,通过缓存可以将频繁使用的数据存储在内存中,以提高数据的读取速度。在PHP中,我们可以使用各种方法来实现数据缓存和读写功能。本文将介绍两种常用的方法:使用文件缓存和使用内存缓存。一、使用文件缓存文件缓存是将数据存储在文件中,以便后续读取。下面是一个使用文件缓存实现数据读写的示例代码:

怎么用phpexcel将Excel文件转成CSV文件并打开怎么用phpexcel将Excel文件转成CSV文件并打开Mar 27, 2023 pm 04:16 PM

​PHPEXCEL是一个优秀的PHP读写Excel文件的类库,它提供了非常充分的API,能够让我们使用PHP来读写Excel文件。而有些时候,我们需要将Excel文件转换成CSV文件,在一些场合下使用。那么,本文主要讲述如何使用PHPEXCEL类库将Excel文件转换成CSV文件,并进行打开。

如何在Go语言中实现封装和继承如何在Go语言中实现封装和继承Jul 23, 2023 pm 08:17 PM

如何在Go语言中实现封装和继承封装和继承是面向对象编程中的两个重要概念,它们可以使代码更加模块化和可维护,同时也为代码的复用提供了便利。本文将介绍在Go语言中如何实现封装和继承,并提供相应的代码示例。封装封装是将数据和功能进行封装,隐藏实现的细节,只暴露必要的接口给外部使用。在Go语言中,封装是通过导出和非导出标识符来实现的。首字母大写的标识符可以被其他包访

揭秘 Java 文件操作的内部原理揭秘 Java 文件操作的内部原理Feb 28, 2024 am 08:22 AM

文件系统APIJava文件操作的内部原理与操作系统的文件系统api密切相关。在Java中,文件操作是由java.NIO包中的java.nio.file模块提供的。该模块提供了对文件系统API的封装,使Java开发者能够在不同的操作系统上使用统一的API进行文件操作。文件对象当Java程序需要访问文件时,它首先需要创建一个java.nio.file.Path对象。Path对象代表了文件系统中的一个路径,可以是绝对路径也可以是相对路径。一旦创建了Path对象,就可以使用它来获取文件的各种属性,如名称

See all articles

핫 AI 도구

Undresser.AI Undress

Undresser.AI Undress

사실적인 누드 사진을 만들기 위한 AI 기반 앱

AI Clothes Remover

AI Clothes Remover

사진에서 옷을 제거하는 온라인 AI 도구입니다.

Undress AI Tool

Undress AI Tool

무료로 이미지를 벗다

Clothoff.io

Clothoff.io

AI 옷 제거제

AI Hentai Generator

AI Hentai Generator

AI Hentai를 무료로 생성하십시오.

뜨거운 도구

드림위버 CS6

드림위버 CS6

시각적 웹 개발 도구

스튜디오 13.0.1 보내기

스튜디오 13.0.1 보내기

강력한 PHP 통합 개발 환경

Eclipse용 SAP NetWeaver 서버 어댑터

Eclipse용 SAP NetWeaver 서버 어댑터

Eclipse를 SAP NetWeaver 애플리케이션 서버와 통합합니다.

mPDF

mPDF

mPDF는 UTF-8로 인코딩된 HTML에서 PDF 파일을 생성할 수 있는 PHP 라이브러리입니다. 원저자인 Ian Back은 자신의 웹 사이트에서 "즉시" PDF 파일을 출력하고 다양한 언어를 처리하기 위해 mPDF를 작성했습니다. HTML2FPDF와 같은 원본 스크립트보다 유니코드 글꼴을 사용할 때 속도가 느리고 더 큰 파일을 생성하지만 CSS 스타일 등을 지원하고 많은 개선 사항이 있습니다. RTL(아랍어, 히브리어), CJK(중국어, 일본어, 한국어)를 포함한 거의 모든 언어를 지원합니다. 중첩된 블록 수준 요소(예: P, DIV)를 지원합니다.

Atom Editor Mac 버전 다운로드

Atom Editor Mac 버전 다운로드

가장 인기 있는 오픈 소스 편집기