PHPExcel 读写封装类
excel
phpexcel
可以
封装
我们
数据
文件
生成
类
读写
读取
对于 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> ?>登录后复制
数据返回的配置，可以看下图：
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
R.E.P.O.能量晶体解释及其做什么（黄色晶体）
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳图形设置
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
刺客信条阴影：贝壳谜语解决方案
2 周前
By DDD
R.E.P.O.如果您听不到任何人，如何修复音频
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解锁Myrise中的所有内容
4 周前
By 尊渡假赌尊渡假赌尊渡假赌
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
热门话题
excel打印表格框线消失怎么办
Mar 21, 2024 am 09:50 AM
如果在打开一份需要打印的文件时，在打印预览里我们会发现表格框线不知为什么消失不见了，遇到这样的情况，我们就要及时进行处理，如果你的打印文件里也出现了此类的问题，那么就和小编一起来学习下边的课程吧：excel打印表格框线消失怎么办？1、打开一份需要打印的文件，如下图所示。 2、选中所有需要的内容区域，如下图所示。 3、单击鼠标右键，选择“设置单元格格式”选项，如下图所示。 4、点击窗口上方的“边框”选项，如下图所示。 5、在左侧的线条样式中选择细实线图样，如下图所示。 6、选择“外边框”
excel同时筛选3个以上关键词怎么操作
Mar 21, 2024 pm 03:16 PM
在日常办公中经常使用Excel来处理数据，时常遇到需要使用“筛选”功能。当我们在Excel中选择执行“筛选”时，对于同一列而言，最多只能筛选两个条件，那么，你知道excel同时筛选3个以上关键词该怎么操作吗？接下来，就让小编为大家演示一遍。第一种方法是将条件逐步添加到筛选器中。如果要同时筛选出三个符合条件的明细，首先需要逐步筛选出其中一个。开始时，可以先根据条件筛选出姓“王”的员工。然后单击【确定】，接着在筛选结果中勾选【将当前所选内容添加到筛选器】。操作步骤如下所示。 同样，再次分别执行筛选
开源！超越ZoeDepth！ DepthFM：快速且精确的单目深度估计！
Apr 03, 2024 pm 12:04 PM
0.这篇文章干了啥？提出了DepthFM：一个多功能且快速的最先进的生成式单目深度估计模型。除了传统的深度估计任务外，DepthFM还展示了在深度修复等下游任务中的最先进能力。DepthFM效率高，可以在少数推理步骤内合成深度图。下面一起来阅读一下这项工作~1.论文信息标题：DepthFM:FastMonocularDepthEstimationwithFlowMatching作者：MingGui,JohannesS.Fischer,UlrichPrestel,PingchuanMa,Dmytr
出现0x80004005错误代码怎么办 小编教你0x80004005错误代码解决方法
Mar 21, 2024 pm 09:17 PM
在电脑中删除或解压缩文件夹，时有时候会弹出提示对话框“错误0x80004005：未指定错误”，如果遇到这中情况应该怎么解决呢？提示错误代码0x80004005的原因其实有很多，但大部分因为病毒导致，我们可以重新注册dll来解决问题，下面，小编给大伙讲解0x80004005错误代码处理经验。有用户在使用电脑时出现错误代码0X80004005的提示，0x80004005错误主要是由于计算机没有正确注册某些动态链接库文件，或者计算机与Internet之间存在不允许的HTTPS连接防火墙所引起。那么如何
PPT幻灯片插入excel图标的操作方法
Mar 26, 2024 pm 05:40 PM
1、打开PPT，翻页至需要插入excel图标的页面。点击插入选项卡。2、点击【对象】。3、跳出以下对话框。4、点击【由文件创建】，点击【浏览】。5、选择需要插入的excel表格。6、点击确定后跳出如下页面。7、勾选【显示为图标】。8、点击确定即可。
谷歌狂喜：JAX性能超越Pytorch、TensorFlow！或成GPU推理训练最快选择
Apr 01, 2024 pm 07:46 PM
谷歌力推的JAX在最近的基准测试中性能已经超过Pytorch和TensorFlow，7项指标排名第一。而且测试并不是在JAX性能表现最好的TPU上完成的。虽然现在在开发者中，Pytorch依然比Tensorflow更受欢迎。但未来，也许有更多的大模型会基于JAX平台进行训练和运行。模型最近，Keras团队为三个后端（TensorFlow、JAX、PyTorch）与原生PyTorch实现以及搭配TensorFlow的Keras2进行了基准测试。首先，他们为生成式和非生成式人工智能任务选择了一组主流
iPhone上的蜂窝数据互联网速度慢：修复
May 03, 2024 pm 09:01 PM
在iPhone上面临滞后，缓慢的移动数据连接？通常，手机上蜂窝互联网的强度取决于几个因素，例如区域、蜂窝网络类型、漫游类型等。您可以采取一些措施来获得更快、更可靠的蜂窝互联网连接。修复1–强制重启iPhone有时，强制重启设备只会重置许多内容，包括蜂窝网络连接。步骤1–只需按一次音量调高键并松开即可。接下来，按降低音量键并再次释放它。步骤2–该过程的下一部分是按住右侧的按钮。让iPhone完成重启。启用蜂窝数据并检查网络速度。再次检查修复2–更改数据模式虽然5G提供了更好的网络速度，但在信号较弱
html怎么读取excel数据
Mar 27, 2024 pm 05:11 PM
html读取excel数据的方法：1、使用JavaScript库读取Excel数据；2、使用服务器端编程语言读取Excel数据。
