php 处理Excel 文件csv

csv 文件格式

<code><span>"数据１"</span>，<span>"数据２"</span>，<span>"数据３"</span><span>"数据４"</span>，<span>"数据５"</span>，<span>"数据６"</span></code>

?将二维数组存为　csv 文件fputcsv()

<code><span>$csv_arr</span> = (    <span>array</span>(<span>1</span>,<span>2</span>,<span>3</span>,<span>4</span>),    <span>array</span>(<span>5</span>,<span>6</span>,<span>7</span>,<span>8</span>),    <span>array</span>(<span>12</span>,<span>34</span>,<span>56</span>,<span>78</span>));<span>$fh</span> = fopen(<span>'test.csv'</span>,<span>'w'</span>) <span>or</span><span>die</span>(<span>"can't open file test.csv"</span>)；<span>foreach</span>(<span>$csv_arr</span><span>as</span><span>$csv_arr_line</span>){    <span>if</span>(fputcsv(<span>$fh</span>,<span>$csv_arr_line</span>) === <span>false</span>){        <span>die</span>(‘can not write test.csv !’)；    }}fclose(<span>$fh</span>) <span>or</span><span>die</span>(<span>"can not close test.csv !"</span>);</code>

想输出　csv 格式的数据　php://output

<code><span>$csv_arr</span> = (    <span>array</span>(<span>1</span>,<span>2</span>,<span>3</span>,<span>4</span>),    <span>array</span>(<span>5</span>,<span>6</span>,<span>7</span>,<span>8</span>),    <span>array</span>(<span>12</span>,<span>34</span>,<span>56</span>,<span>78</span>));<span>$fh</span> = fopen(<span>'php://output'</span>,<span>'w'</span>);<span>foreach</span>(<span>$csv_arr</span><span>as</span><span>$csv_arr_line</span>){    <span>if</span>(fputcsv(<span>$fh</span>,<span>$csv_arr_line</span>) === <span>false</span>){        <span>die</span>(‘can not write csv line !’)；    }}fclose(<span>$fh</span>);</code>

?想将　csv 格式的数据存到字符串中 ob buffer

<code><span>$csv_arr</span> = (    <span>array</span>(<span>1</span>,<span>2</span>,<span>3</span>,<span>4</span>),    <span>array</span>(<span>5</span>,<span>6</span>,<span>7</span>,<span>8</span>),    <span>array</span>(<span>12</span>,<span>34</span>,<span>56</span>,<span>78<strong style="color:transparent">￥本文来源gaodai#ma#com搞@@代~&码网^</strong><small>搞gaodaima代码</small></span>));ob_start();<span>$fh</span> = fopen(<span>'test.csv'</span>,<span>'w'</span>) <span>or</span><span>die</span>(<span>"can't open php://output"</span>)；<span>foreach</span>(<span>$csv_arr</span><span>as</span><span>$csv_arr_line</span>){    <span>if</span>(fputcsv(<span>$fh</span>,<span>$csv_arr_line</span>) === <span>false</span>){        <span>die</span>(‘can not write csv line !’)；    }}fclose(<span>$fh</span>) <span>or</span><span>die</span>(<span>"can not close php://output !"</span>);<span>$output</span> = ob_get_contents();ob_end_clean();</code>

版权声明：知识取之于民，用之于民！欢迎转载，转载请开头附上本文链接，不定期更新文章！

以上就介绍了php 处理Excel 文件csv，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。

---

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php 处理Excel 文件csv

喜欢 (0)赏

[搞代码]

分享 (0)